On Thu, 22 Mar 2001 17:01:35 -0600, "Cal Evans" <[EMAIL PROTECTED]> wrote:
Thank Cal, I found the problem in our coding, not the query, so it works fine
now! My apologies to the list.
Appreciate the help :)
>>Try
>>
>>Select * from table where upper(bus_name)= upper('whater I am searching
>>for');
>>
>>Cal
>>http://www.calevans.com
>>
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED]]On Behalf
>>Of Mike<mickalo>Blezien
>>Sent: Thursday, March 22, 2001 4:02 PM
>>To: [EMAIL PROTECTED]
>>Subject: Case Sensitive??
>>
>>
>>Hello All,
>>
>>I have a table with a column called "bus_name" varchar(100) which is used in
>>a
>>Business Name search form. I need to make the Business Name that is entered
>>into
>>the search form case in-sensitive to the column "bus_name" IE. If we have a
>>entry in the column "bus_name" "The Happy Shop", and someone enters "the
>>happy
>>shop" or "THE HAPPY SHOP", it will still return a match. If I add the
>>attribute
>>"BINARY" to the colunm "bus_name" will this make it case-insensitive or is
>>there
>>another way to do this within the SQL query??
>>
>>TIA,
>>
>>
>>Mike(mickalo)Blezien
>>========================================
>>Thunder Rain Internet Publishing
>>Providing Internet Solutions that work!
>>http://www.thunder-rain.com
>>Tel: 1(225) 686-2002
>>=========================================
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
