The common trick for case-insensitive searching is "UPPER(col) LIKE
'%FOO%'".  However, UPPER is not valid for text columns.  Is there a
way to make LIKE/PATINDEX case-insensitive, or some other solution to
this problem?

I've scanned the Sybase manuals, without finding much that even
mentions the case-sensitive vs. insensitive problem.

--
Rune Fr?ysa

You can define a server-wide case-insensitive sort order. Unfortunately,
this will require DBCC of all objects, since some of the indexes may
fail. Also all servers in the enterprise should switch to this sort order
or you won't be able to load data across servers. That's a massive and
very general solution for your problem.

If you will be doing much searching on text blobs, you should have a look
at
the Full Text Search Engine component.

-bret

Rune,

One option is the enhance Sybase with OMNIDEX advanced indexing, which
gives you case-insensitive keyword searches.  For more information,
see http://www.disc.com/keyword.html or contact me.

Cheryl Grandy

303 444-4000
www.disc.com/home

--
Cheryl Grandy
DISC
Get OMNIDEX for the fastest
applications ever

Sent via Deja.com http://www.deja.com/
Before you buy.