Case sensitivity in SQL -- ignore

Hi,

I believe my SQL server was configured as Case sensitivity. I have a
number of stored procedures which were moved from a non-Case
sensitivity SQL server. Because of the Case sensitivity, I have to do
a lot of editing in those stored procedures. Is there a quick way to
avoid the editing?

Something like ignoring the case in one statement?

Thanks in advance, your advice will be greatly appreciated.On Mar 14, 11:59 pm, sweetpota...@.yahoo.com wrote:

Quote:

Originally Posted by

Hi,
>
I believe my SQL server was configured as Case sensitivity. I have a
number of stored procedures which were moved from a non-Case
sensitivity SQL server. Because of the Case sensitivity, I have to do
a lot of editing in those stored procedures. Is there a quick way to
avoid the editing?
>
Something like ignoring the case in one statement?
>
Thanks in advance, your advice will be greatly appreciated.

I think by changing the collation of your database to case
insenstitvity may help
but this may cause problems when you create #temp tables as tempdb
will have server collation

If your column and table names are in lower case , you can modify the
SP by selecting the SP and changing to lowercase (SHIFT+CTRL+L) . But
if you have string constants which need to be in uppercase , you need
to change it accordingly

M A Srinivas|||>I believe my SQL server was configured as Case sensitivity. <<

As it should be; that is how Standard SQL is defined

Quote:

Originally Posted by

Quote:

Originally Posted by

>Because of the Case sensitivity, I have to do a lot of editing in those stored procedures. <<

Life is tough when someone screws up. You need to just do it right
and stop looking for kludges. Oh, and if yuou can kill them guy that
did this, you will probably improve the quality of your company's
software in other places as well.