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.

****problem in searching using sybase

2 posts in Windows NT Last posting was on 2000-07-13 20:53:03.0Z
andrew Posted on 2000-05-25 10:19:05.0Z
Message-ID: <392CFE19.D4B12F55@cyber-village.net>
Date: Thu, 25 May 2000 18:19:05 +0800
From: andrew <andrewlee@cyber-village.net>
X-Mailer: Mozilla 4.7 [en-gb] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: ****problem in searching using sybase
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 23
NNTP-Posting-Host: 202.186.196.38
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2109
Article PK: 1089517

Dear people;
I am having a problem in searching data in sybase. There are two fields
in a table which contains data about stock tickers and tickers name.

tickers tickerName
AII123 Kuala Lumpur Composite

I am using sql to search for the tickerName in my table. My select
statement is as below.
select * from table where tickerName='$var'

I am using php as my programming language.
My problem is the variable $var is actually taken from a textfield. The
search works fine when user actually type 'Kuala Lumpur Composite' and
there is a perfect match. My problem is the user might type everything
in lower case or a mix of uppercase and lowercase. When this happen, no
match can be found. Is there a way to rectify this problem. PLease help
as i'm near my dateline.
thanks
andrew
PS: can you please cc any answer to andrewlee@mailcity.com
thanks you very much


fatene mathias Posted on 2000-07-13 20:53:03.0Z
From: "fatene mathias" <mohdoukali@aol.com>
Subject: Re: ****problem in searching using sybase
References: <392CFE19.D4B12F55@cyber-village.net>
Message-ID: <01bfed09$ddfe91c0$779900c1@fatene>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 13 Jul 2000 16:53:03 -0400
Lines: 28
NNTP-Posting-Host: ACA949D1.ipt.aol.com 172.169.73.209
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1892
Article PK: 1089304

select * from table where lower(tickerName)='$var'

andrew <andrewlee@cyber-village.net> a écrit dans l'article
<392CFE19.D4B12F55@cyber-village.net>...

> Dear people;
> I am having a problem in searching data in sybase. There are two fields
> in a table which contains data about stock tickers and tickers name.
>
> tickers tickerName
> AII123 Kuala Lumpur Composite
>
> I am using sql to search for the tickerName in my table. My select
> statement is as below.
> select * from table where tickerName='$var'
>
> I am using php as my programming language.
> My problem is the variable $var is actually taken from a textfield. The
> search works fine when user actually type 'Kuala Lumpur Composite' and
> there is a perfect match. My problem is the user might type everything
> in lower case or a mix of uppercase and lowercase. When this happen, no
> match can be found. Is there a way to rectify this problem. PLease help
> as i'm near my dateline.
> thanks
> andrew
> PS: can you please cc any answer to andrewlee@mailcity.com
> thanks you very much
>
>