This is a multi-part message in MIME format.

------=_NextPart_000_0022_01C091C8.B406DFD0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

RE: [sql_language] double and single quotesThanks, I fixed some other way.
If someone needs it, here it is

dogsQLACC="SELECT * From tbs_bars
dogsSQLACC=dogsSQLACC & " WHERE sRunner=""" & sRunningDog & """"
dogsSQLACC=dogsSQLACC & ";"

  -----Original Message-----
  From: Francois_Vallieres@I...
[mailto:Francois_Vallieres@I...]
  Sent: Thursday, February 08, 2001 11:00 AM
  To: sql language
  Subject: [sql_language] RE: double and single quotes


  Hi,

  Use a REPLACE function, changing ' for two ''

  Like REPLACE(sResBistro, "'", "''")

  It should work.

  -------------------------------------------------
  Francois Vallieres
  Observatoire des Sciences et des Technologies




  > -----Original Message-----
  > From: Jose-Pablo Lopez [mailto:systems@d...]
  > Sent: 8 février, 2001 10:02
  > To: sql language
  > Subject: [sql_language] double and single quotes
  >
  >
  > Please I need help with this statement
  >
  > I need to SELECT a name with an apostrophe  "Mel's Bistro"
  > and I can not get
  > it nor what to do.
  >
  > dogSQLACC = "SELECT * From tba_bars"
  >       dogSQLACC = dogSQLACC & " WHERE sRestaurant='" &
  > sRestBistro & "'"
  > >>>>>>>> Here is the error<<<<<<<<<
  >       dogSQLACC = dogSQLACC & ";"
  >
  > How do I locate the double quotes and the single quotes
  >
  > Thanks
  >
  >
  > francois_vallieres@i...
  > $subst('Email.Unsub')
  >

webmaster@g...