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" <amird@sgnetway.com> wrote in message
news:094601c3957e$88d84a80$a101280a@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"