Select statement

[Former Member]

I want to use a "select" statement to retreive records that match no matter the capitalization.

eg. if the world is "MyTestStRinG" then entering "myteststring" should find a match.

I hate to read everything then convert it to Upper or lower case to compare.

[raja_thangamani]

You can't do that unless until you convert into Lower or Upper case.

Raja T

[Former Member]

well, i was afraid there was no other alternative.

wait a little to offer points

thanks

[Former Member]

thanks

[Former Member]

did i give you any points?