[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