Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

decode?

Status
Not open for further replies.
Stevennn

Stevennn

Programmer
Apr 4, 2007
52
US
I'm trying to pull a column name Month_Year the value is Jan-2005. How can i make my extract look likt this: "JAN"?


thank-you
 
Sort by date Sort by votes
If "Month_Year" is a character column (e.g. VARCHAR2), then you can extract an uppercase month abbreviation with:
Code: 
SELECT upper(substr(Month_Year,1,3))...
Let us know if this resolves your need.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

getjbb
  • Locked
  • Question
Using Decode
Replies
8
Views
206
getjbb
getjbb
getjbb
  • Locked
  • Question
Call Decode Result In a Function
Replies
2
Views
118
getjbb
getjbb
raddycal
  • Locked
  • Question
decode with group by 2
Replies
4
Views
551
raddycal
raddycal
nkshah
  • Locked
  • Question
Dynamic Decode function - is it possible ?
Replies
3
Views
131
LKBrwnDBA
LKBrwnDBA
AndersonCJA
  • Locked
  • Question
Can the Subquery be replaced with decode? How? 1
Replies
10
Views
170
AndersonCJA
AndersonCJA

Part and Inventory Search

Sponsor

Back
Top