Search On FOX Data!

[Amir Davoodi]

Dear Friends,
I've got a web application using ASP, 65001 codepage and
Microsft Access As DataStore.
I have imported some data from FOX(DOS) into access and
when I try to search on this data using T-SQL LIKE, it
dosn't work correctly.
Would you please help me,

Thanks,
Amir Davoodi.

[Dan Sikorsky]

T-SQL uses LIKE '%abc%' syntax
ACCESS uses LIKE '*abc*' syntax

"Amir Davoodi" <am***@sgnetway.com> wrote in message
news:09****************************@phx.gbl...

Dear Friends,
I've got a web application using ASP, 65001 codepage and
Microsft Access As DataStore.
I have imported some data from FOX(DOS) into access and
when I try to search on this data using T-SQL LIKE, it
dosn't work correctly.
Would you please help me,

Thanks,
Amir Davoodi.

[Bob Barrows]

Dan Sikorsky wrote:

T-SQL uses LIKE '%abc%' syntax
ACCESS uses LIKE '*abc*' syntax

This is true. However, if you use dynamic sql from your asp app, then you
must use the ODBC wildcards: % and _. No matter what the database is.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"