It's working....Thanks

___\\|//___
((((('O O' )))))
ooO-(_)-Ooo---------------------------->
Sébastien Bois
page  (xxx)xxx-xxxx
Montréal, Canada
Courriel jumo.bwa@s...
Icq # 6023776


-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 26 novembre, 2000 21:26
To: sql language
Subject: [sql_language] Re: ASP SQL statment problem


http://www.adopenstatic.com/faq/likequeries.asp

Cheers
Ken

----- Original Message -----
From: "Sebastien Bois" <jumo.bwa@s...>
To: "sql language" <sql_language@p...>
Sent: Sunday, November 26, 2000 2:24 PM
Subject: [sql_language] ASP SQL statment problem


> Hi,
> I wrote an sql statement to ask an asp script to look in the part of
> a database text field.
> I tried this one
>
> SELECT TblFrenchTerms.TermID,TblFrenchTerms.Term,
> TblFrenchTerms.Definition FROM tblFrenchTerms WHERE
> (((tblFrenchTerms.Definition) LIKE '*signal*'))
>
> because MS access accept it but in ASP it doesn't work.....
> Asp is looking for the word *signal*....
> Do u have an idea ???
>
> Franck Sébastien Bois
> PS : Please answer me ASAP
> Thanks