WinSQL Question

[bakerm]

I need to know how to handle case sensitivity in WinSQL.

For instance, if there were a record in the DB with a partnumber of 'AA' and I performed a search for partnumber 'aa' WinSQL WILL NOT return the 'AA' record.
This may seem trivial but I need to do it never the less.

Thanks in advance for any suggestions.

Mark

 

[foxdev]

Hi, Mark. This is a forum for Microsoft SQL Server, not WinSQL. If you were talking about SQL Server, then the answer depends on the sort order used by your installation. The default is case insensitive, meaning 'AA' = 'aa'. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org