How to match Large and Small Letter

shr_amar · Active User Joined: 02 May 2005 Posts: 128 Location: UK

Hello ,

Can we match Large letter & small Letter
For example if we have two variablles which contain value as follows .

Variable1 = 'TEST'
Variable2 = 'test'
when i am comparing both variable it is saying variable not matching

Is there any way to match large and small letter .

One more thing i have extracted the values using STRIP command
STRIP(SUBSTR(ElementCode.MCnt,10,4))

Please Guide

cpuhawg · Posted: Tue Feb 05, 2008 6:58 pm

You can use the UPPER command on the lower case variable and then do the comparison.