Wildcard Search

I have the following SQL statement that returns a result set based on the exact input stored in a session variable

If reqname <> "" Then
strSQL = strSQL & "AND(ABR_REQUESTOR='" & reqname & "')"

The variable “reqname” is set to a session variable.

I amended the SQL to do a wildcard search instead of searching for the exact string stored in the Session variable:

I altered the SQL as follows:

strSQL = strSQL & "AND(ABR_REQUESTOR LIKE '" & reqname & "%')"

The problem is the field ABR_REQUESTOR stores the first and last name separated 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?