[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