Skip to Content
0
Former Member
Feb 13, 2007 at 10:32 PM

Select statement

25 Views

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.