Searching records with 'like'

microsoft.public.sqlserver.programming

25 Nov 2005 2:11 PM

Pavils Jurjans

Hello,

I have this table with ID field and text field. For certain purposes, I need
to save this text field with case-sensitive collation. However, in some
cases I need to look up matches, ignoring the case, using like operator. How
can I override the default collation in this on-the-fly query?

Thanks,

Pavils

25 Nov 2005 2:27 PM

you can use COLLATE option i the select statement and specifiy what
collation you would like to use for the query. Alternatively, you could use
upper function.

MC

Show quote

"Pavils Jurjans" <pav***@mailbox.riga.lv> wrote in message
news:%23nWRJnc8FHA.1280@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> I have this table with ID field and text field. For certain purposes, I
> need to save this text field with case-sensitive collation. However, in
> some cases I need to look up matches, ignoring the case, using like
> operator. How can I override the default collation in this on-the-fly
> query?
>
> Thanks,
>
> Pavils
>