wildcard search

[-D-]

I have the following SQL that searches based on the exact input stored in a
session variable If reqname <> '' Then strSQL = strSQL &amp;
'AND(ABR_REQUESTOR='' &amp; reqname &amp; '')' The variable reqname is set to
a session variable Session('requestor') I'd like to ammend the SQL to do a
wildcard search instead of searching for the exact string stored in the Session
variable: Something like: If reqname <> '' Then strSQL = strSQL &amp;
'AND(ABR_REQUESTOR LIKE %)' How can I ammend the line to properly do a
wildcard search? Thanks, -D-

[Julian Roberts]

You can use LIKE. eg where foo like '%'

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[-D-]

yeah, I altered the SQL as follows: strSQL = strSQL &amp; 'AND(ABR_REQUESTOR
LIKE '' &amp; reqname &amp; '%')' The problem is the field ABR_REQUESTOR
stores the first and last name seperated by a space...i.e. John Smith Using
the above SQL will return John Smith if I use J, Jo, Joh. But, if I want to
search for Smith by using S, or Sm, etc. it won't work. I need to alter the
statement to look for anything after a space? Not sure how to do this?
Thanks, -D-

[Julian Roberts]

Maybe like: where foo like '%sm%'

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004