[thelist] ASP ADO Quirks?
Burhan Khalid
burhankhalid at members.evolt.org
Tue Nov 12 11:43:01 CST 2002
AB> At 09:01 AM 11/12/2002, Burhan Khalid wrote:
>> "WHERE " &_
>> "(((ArtAds.ArtAdArtist) Like '*" & strSearchText & "*')) " &_
>> "OR (((ArtAds.ArtAdDesc) Like '*" & strSearchText & "*')) " &_
>> "OR (((Categories.CategoryDesc) Like '*" & strSearchText & "*')) " &_
>> "OR (((Subjects.SubjectDesc) Like '*" & strSearchText & "*'));"
AB> Instead of * try %.
Isn't the wildcard * instead of % on SQL Server?
--
*---------------*
| Burhan Khalid |
*---------------*---------------------------*
| Email : burhankhalid[at]members.evolt.org |
| Web : members.evolt.org/burhankhalid |
*-------------------------------------------*
More information about the thelist
mailing list