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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Expression Needed (If 4th digit is a 4 then "S" else if 6 then "U

Status
Not open for further replies.
kernal

kernal

Technical User
Feb 27, 2001
415
US
I'm using the Peoplesoft Query Manager:

I have a field. Example:

1064
1066
1068

Fourth digit: If 4 then "S" else if 6 then "U" else if "8" then "F"

then take the second and third digits so my results would be:

S06
U06
F06

Help is appreciated.
 
Sort by date Sort by votes
Hurray, I found out how to do it.
 
Upvote 0 Downvote
SUBSTR is a beautiful instruction, isn't it?

Steve N.
State of Ohio, MIS
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ktonthat
  • Locked
  • Question
Where do we update the SQR process email address list
Replies
0
Views
114
Ktonthat
Ktonthat
Ktonthat
  • Locked
  • Question
TAX UPDATE & PROJECT
Replies
0
Views
108
Ktonthat
Ktonthat
Ktonthat
  • Locked
  • Question
Which user
Replies
0
Views
97
Ktonthat
Ktonthat
Ktonthat
  • Locked
  • Question
Tax Class and Earning code
Replies
0
Views
265
Ktonthat
Ktonthat
Ktonthat
  • Locked
  • Question
TAX CLASS & EARNING CODE
Replies
0
Views
114
Ktonthat
Ktonthat

Part and Inventory Search

Sponsor

Back
Top