Case-insensitive search in text columns 
Author Message
 Case-insensitive search in text columns
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



Mon, 20 Jan 2003 03:00:00 GMT
 Case-insensitive search in text columns

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.
Quote:

> 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



Mon, 20 Jan 2003 03:00:00 GMT
 Case-insensitive search in text columns
If you will be doing much searching on text blobs, you should have a look
at
the Full Text Search Engine component.

-bret

Quote:

> 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



Mon, 20 Jan 2003 03:00:00 GMT
 Case-insensitive search in text columns
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



Quote:
> 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

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

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



Fri, 14 Feb 2003 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. fastest full text search with case sensitive/insensitive

2. Case insensitive search on text field

3. case-insensitive text searches

4. text case-insensitive search

5. create index on text column, case insensitive?

6. case insensitive searches against case sensistive fields

7. How to use both case sensitive and case insensitive search

8. mixed case (case-insensitive) searching with FoxPro ODBC MS drivers

9. case insensitive searches?

10. case-insensitive search

11. CASE INSENSITIVE SEARCH --- HOW???


 
Powered by phpBB® Forum Software