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_descrip tion, product_price " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_descrip tion 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******** *****@TK2MSFTNG P10.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_descrip tion,
product_price " &_
: "FROM Products " &_
: "WHERE product_status = 1 " &_
: "AND ( product_name LIKE '%" & searchFor & "%' " &_
: "OR product_descrip tion 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_n ame) LIKE '%" & ucase(searchFor ) & "%' " &_
"OR UPPER(product_d escription) 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******** *****@TK2MSFTNG P10.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_descrip tion, product_price " &_ "FROM Products " &_
"WHERE product_status = 1 " &_
"AND ( product_name LIKE '%" & searchFor & "%' " &_
"OR product_descrip tion 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...