[thelist] ASP ADO Quirks?
Anthony Baratta
Anthony at Baratta.com
Tue Nov 12 11:29:01 CST 2002
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 & "*'));"
Instead of * try %.
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list