Skip to Content
0
Former Member
Oct 05, 2009 at 12:19 PM

Select in both upper and lower case on text tables- Is it possible

2292 Views

Hi all,

I have below data in my data base.

SULPH1

SULPH2

Sulph3

I am querying the descritpion table with like operatior. if I query with SUL, I am getting 2 records, If I query with Sul I am getting only one record. it is possible to get all the 3 reocrds in one search like SUL or Sul?

Thanks in Advacne.

Vr reddi.