Syntax error in SQL

[Dutchy]

Following SQL statement returns a syntax error
SQL_mut = "SELECT MUTUAL.STRAAT, MUTUAL.PLAATS, MUTUAL.POSTNUMMER,
MUTUAL.NAAM FROM MUTUAL WHERE MUTUAL.NAAM = '" & TB_pat!BOND & "'; "

The output is

SELECT MUTUAL.STRAAT, MUTUAL.PLAATS, MUTUAL.POSTNUMMER, MUTUAL.NAAM FROM
MUTUAL WHERE MUTUAL.NAAM = 'FED.DER BEROEPSMUTUALITEITEN A'PEN';

The syntax error occurs because TB_pat!Bond for a record is 'FED.DER
BEROEPSMUTUALITEITEN A'PEN
the ' in A'PEN cause the problem

How to avoid the error??

Thanks

 

[fredg]

Following SQL statement returns a syntax error
SQL_mut = "SELECT MUTUAL.STRAAT, MUTUAL.PLAATS, MUTUAL.POSTNUMMER,
MUTUAL.NAAM FROM MUTUAL WHERE MUTUAL.NAAM = '" & TB_pat!BOND & "'; "

The output is

SELECT MUTUAL.STRAAT, MUTUAL.PLAATS, MUTUAL.POSTNUMMER, MUTUAL.NAAM FROM
MUTUAL WHERE MUTUAL.NAAM = 'FED.DER BEROEPSMUTUALITEITEN A'PEN';

The syntax error occurs because TB_pat!Bond for a record is 'FED.DER
BEROEPSMUTUALITEITEN A'PEN
the ' in A'PEN cause the problem

How to avoid the error??

Thanks

use:
WHERE MUTUAL.NAAM = " & chr(34) & TB_pat!BOND & chr(34) & "; "

becomes
WHERE MUTUAL.NAAM = "FED.DER BEROEPSMUTUALITEITEN A'PEN";

 

[Marshall Barton]

Following SQL statement returns a syntax error
SQL_mut = "SELECT MUTUAL.STRAAT, MUTUAL.PLAATS, MUTUAL.POSTNUMMER,
MUTUAL.NAAM FROM MUTUAL WHERE MUTUAL.NAAM = '" & TB_pat!BOND & "'; "

The output is

SELECT MUTUAL.STRAAT, MUTUAL.PLAATS, MUTUAL.POSTNUMMER, MUTUAL.NAAM FROM
MUTUAL WHERE MUTUAL.NAAM = 'FED.DER BEROEPSMUTUALITEITEN A'PEN';

The syntax error occurs because TB_pat!Bond for a record is 'FED.DER
BEROEPSMUTUALITEITEN A'PEN
the ' in A'PEN cause the problem

Either double up the single quote in the Bond value:

. . . '" & Replace(TB_pat!BON, "'", "''") & "'; "

or use double quotes around the value:

. . . """ & TB_pat!BON & """; "

 

[Dutchy]

Both solutions work... thnaks
JP

Either double up the single quote in the Bond value:

. . . '" & Replace(TB_pat!BON, "'", "''") & "'; "

or use double quotes around the value:

. . . """ & TB_pat!BON & """; "