Turning off case sensitive search 1

[dmilgram]

How does one indicate that the key search in a particular column is not case sensitive? Currently,one has to get the case exactly right in order for a match on a query to work. How does one make SQL ignore case in specific columns?

 

[calahans]

As far as I remember its an option in the setup of SS. <br>
<br>
You can rerun the setup again without overwriting your databases.

 

[jnicho02]

You cannot make specific columns case-insensitive, only your whole server.<br>
<br>
If you run 'sp_helpsort' it will tell you all about your charset and sort order. The default is case-insensitive and I would be surprised if yours is case-sensitive, if so then it was changed for a reason.<br>
<br>
The sort order can be changed by re-running the install, but you will need to rebuild your database and reload your data....<br>
<br>
I tended to get round it by using the UPPER function, e.g.<br>
<br>
SELECT Cust_details from customer<br>
where UPPER(Custname) = &quot;BLOGGS&quot;<br>
<br>
This may however stop the index being used and reduce performance.