MVSFORUMS.com

jagan · Beginner Joined: 27 Jan 2003 Posts: 5 Topics: 4

hi
i have table with all lowecase values in columns.
i want to display them in uppercase.

is there any functions like upper or ucase?

but in my spufi i have given select upper(name) from emp;
but it is giving -104 sqlcode.
pl give me the solution
bye

jaichenchlani · Beginner Joined: 31 Mar 2003 Posts: 5 Topics: 2

Hi Jagan,
UPPER as well as LOWER works!! I tried it in my spufi.
_________________
Thanks,
Jai

kolusu · Posted: Thu Apr 10, 2003 6:17 am Post subject:

Jagan,

May be you are having junk information in columns 73-80 that are not displaying on your screen.so clear them and rerun your query

Kolusu