case sensitivity is determined by the sort order; this can only be changed
by reloading the server.
If you are using a code page with case-insensitivity, you cannot use
case-sensitive searches with the LIKE clause. If you ARE using a
case-sensitive code page, you can fake it:
Of course, this is just a sample that uses dynamic SQL for demonstration and
lousy performance. Keep in mind that using functions such as UPPER() is a
statement will also kill performance.
Hope this helps...
> I'm am trying to be able to select records using 'like'
> but would like to be able to control whether I'm looking
> for a case sensitive or insensitive string.
> Does anyone know whether this is possible? I have searched
> MSDN and looking at a couple othe SQL sites. I'm using SQL 6.5
> by the way.