Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

case insensitivity

2 posts in Windows NT Last posting was on 2000-12-15 18:59:00.0Z
Anonymous Posted on 2000-12-15 18:39:01.0Z
From: Anonymous@sybase.com
Date: Fri, 15 Dec 2000 13:39:01 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: case insensitivity
Message-ID: <A8F19C59B93BC5510066733A852569B6.00667347852569B6@webforums>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1390
Article PK: 1088858

Someone has done this?

SELECT * FROM table WHERE table.text LIKE '%SEARCH%'

will return only all rows where data contains matches of 'SEARCH',
what I need is to obtain also the 'search', 'Search', ..., etc, matches.
Any idea?

Thanks.


Bret Halford Posted on 2000-12-15 18:59:00.0Z
Message-ID: <3A3A69F4.A4C747D0@sybase.com>
Date: Fri, 15 Dec 2000 11:59:00 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: ja,en
MIME-Version: 1.0
Subject: Re: case insensitivity
References: <A8F19C59B93BC5510066733A852569B6.00667347852569B6@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1389
Article PK: 1088855

You can do

select * from table where lower(table.text) like "%search%"

or

select * from table where table.text like "%[Ss][Ea][Aa][Rr][Cc][Hh]%"

go

Anonymous@sybase.com wrote:

> Someone has done this?
>
> SELECT * FROM table WHERE table.text LIKE '%SEARCH%'
>
> will return only all rows where data contains matches of 'SEARCH',
> what I need is to obtain also the 'search', 'Search', ..., etc, matches.
> Any idea?
>
> Thanks.