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

creating prompts with the upper function

Status
Not open for further replies.
hicks

hicks

Programmer
Sep 25, 2000
14
0
0
GB
I have a prompt in a report using the decode statement.
I would like to include the upper function within this decode statement. Is this possible?

eg.

decode(Employee.Name,'Jim Brown','JIM','Susan Brown','SUSAN')
 
Status
Not open for further replies.

Similar threads

TracieN
  • Locked
  • Question
Previous Function in Webi
Replies
1
Views
133
kray4660
kray4660
JOEYB99
  • Locked
  • Question
Problem with Webi Hyperlink to SAP t-code CATS_DA
Replies
0
Views
82
JOEYB99
JOEYB99
Clappy2000
  • Locked
  • Question
Date Prompt in Freehand SQL excluding the Time (Web Rich Client Report)
Replies
0
Views
104
Clappy2000
Clappy2000
Emmy2368
  • Locked
  • Question
Creating Year to Date Filter
Replies
4
Views
101
Emmy2368
Emmy2368
PWD
  • Locked
  • Question
Copy As Text Produces All The Columns + 1
Replies
2
Views
40
PWD
PWD

Part and Inventory Search

Sponsor

Back
Top