HI,

I am using this sql statement in ASP using access

strSQL = "SELECT * FROM singles " & "WHERE fleet LIKE '%" & Replace(strSearch, "'", "''") & "%' "& "ORDER BY " & strOrderBy & ";"

Which works fine except If I look for C
I also get records including CR and LTC

Must be something simple I guess

Thanks

Roy..,

Hi Roy,

You should drop the percentage characters. Searching for '%C%' finds anything that contains a C anywhere.

Searching for 'C' instead searches for an exact match of C....

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you so much, fixed in a flash

Kind regards

Roy..