View previous topic :: View next topic |
Author |
Message |
schintala Beginner
Joined: 18 May 2005 Posts: 108 Topics: 31 Location: USA
|
Posted: Fri Jun 17, 2005 9:16 am Post subject: How to differ Case Sensitive in select statement? |
|
|
Hi,
When I browse the below query on our DB through QMF/SPUFI I am not able to retrieve the data even though we have matched rows in table.
SELECT * FROM IDTOUT01.ITOUIN32
WHERE OUTCAT = 'PROBLEM SEVERITY' AND OUTLABEL = 'BREAKING RULES';
In Table ITOUIN32 data under OUTLABEL column stored in lower case letters. How can I retrieve the data? |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12382 Topics: 75 Location: San Jose
|
Posted: Fri Jun 17, 2005 9:54 am Post subject: |
|
|
Schintala,
You can use the scalar function uppercase (UCASE) to get the desired results.
Code: |
SELECT *
FROM IDTOUT01.ITOUIN32
WHERE UCASE(OUTCAT) = 'PROBLEM SEVERITY'
AND UCASE(OUTLABEL) = 'BREAKING RULES'
;
|
Check this links for a detailed explanation of LCASE and UCASE
LCASE
UCASE
Hope this helps...
Cheers
kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
schintala Beginner
Joined: 18 May 2005 Posts: 108 Topics: 31 Location: USA
|
Posted: Fri Jun 17, 2005 9:58 am Post subject: |
|
|
Hi Kolusu,
Thank you very much. It worked. I was using LOWER function in select. |
|
Back to top |
|
 |
|
|