Is it possible to query on case sensitivity? If so how?

Ie

it <> IT
but
IT = IT

Also I have a string, I want to return a case sensitive part of that string. so if my string is:

"IT is putting in new computers."

I want my field to return to a new field: "IT"

but in another record I have:
"The People are great but it is a hassle to create a new system"

I want my field to return: "it"

Any suggestions on how to solve these two problems? Thanks

Case sensitivity exists by default I think, if you want to ignore it, use the UPPER() or LOWER() functions when doing comparisons.

Try reading this for some ideas. Good luck.

http://support.microsoft.com/?kbid=209674


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division