Not a case sensitive search?

[chelleybabyger]

Below is my sql search code in my asp page. But my search seems to be case sensitive. How can i modify it to make it not case sensitive? Thanks

<%
sqlString = "SELECT product_image, product_name, product_description, product_price " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_description LIKE '%" & searchFor & "%') " &_
"ORDER BY product_name "

SET RS = Conn.Execute( sqlString )
IF NOT RS.EOF AND searchFor <> "" THEN
%>
************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Ken Schaefer]

What database are you using? Does it have an option to enable Case Sensitive
matching? Most databases are case insensitive.

Cheers
Ken

"Michelle" <ch************@hotmail.com> wrote in message
news:e4*************@TK2MSFTNGP10.phx.gbl...
: Below is my sql search code in my asp page. But my search seems to be case
sensitive. How can i modify it to make it not case sensitive? Thanks
:
: <%
: sqlString = "SELECT product_image, product_name, product_description,
product_price " &_
: "FROM Products " &_
: "WHERE product_status = 1 " &_
: "AND ( product_name LIKE '%" & searchFor & "%' " &_
: "OR product_description LIKE '%" & searchFor & "%') " &_
: "ORDER BY product_name "
:
: SET RS = Conn.Execute( sqlString )
: IF NOT RS.EOF AND searchFor <> "" THEN
: %>
:
:
: ************************************************** ********************
: Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
: Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

[Tim Williams]

"AND ( UPPER(product_name) LIKE '%" & ucase(searchFor) & "%' " &_
"OR UPPER(product_description) LIKE '%" & ucase(searchFor) & "%') "
&_

modify case functions to suit your environment. Note that this will
impact performance since indexes may not be used. If you notice a big
difference then you might consider creating additional upper-cased
fields in your table just for searching against.

Tim.
"Michelle" <ch************@hotmail.com> wrote in message
news:e4*************@TK2MSFTNGP10.phx.gbl...

Below is my sql search code in my asp page. But my search seems to be case sensitive. How can i modify it to make it not case sensitive?
Thanks
<%
sqlString = "SELECT product_image, product_name, product_description, product_price " &_ "FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_description LIKE '%" & searchFor & "%') " &_
"ORDER BY product_name "

SET RS = Conn.Execute( sqlString )
IF NOT RS.EOF AND searchFor <> "" THEN
%>
************************************************** ******************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &

ASP.NET resources...