This is a multi-part message in MIME format.

------=_NextPart_000_016B_01C059E4.F1E36100
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hi,

you have to use '%signal%' not '*signal*'

jigs
  ----- Original Message -----
  From: Rowena Perks
  To: sql language
  Sent: Friday, November 24, 2000 4:04 PM
  Subject: [sql_language] sql statement problem


  ----Original Message-----
  From: Bois, Sebastien [mailto:Sebastien_Bois@s...]
  Sent: 23 November 2000 20:26
  To: philp@w...
  Subject: SQL



  Hi, maybe you can help me.
  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=E9bastien Bois

  ---
  Wrox Professional Web Developer Conference II
  http://www.wroxconferences.com/WebDevEurope
  November 29th - December 1st 2000, Amsterdam, Netherlands
  Create powerful distributed web applications serving you now and
  in the future. From ASP+ and VB.NET to XML and SQL Server 2000
$subst('Email.Unsub')