>Hi,
>
>I have been doing some tests in a stored procedure and noticed that the SQL Select is not case sensitive. For example,
>
>
>
>select * from MyTable where EmailAddr = 'FirstName@gmail.com'
>select * from MyTable where EmailAddr = 'fIrstNamE@GMAIL.com'
>
>
>
>My understanding is that this is defined by a global setting in SQL Server and this is what it is probably set in my copy of SQL Server. My question, when writing code for my SPs, should I rely on the fact that most SQL servers will be ok with not using case sensitive syntax? Or would it be wiser, to account for case in SQL Select statements? TIA.
Collation is set per database and controlls case sensitivity among other things.
see
http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________