Quotes within a string variable

[SAC]

I'm not sure how to handle quotes within a string variable.

The variable is: "REV "D" DATED 03-07-00"

The quotes above are part of the literal varibale stored in a field in a
table.

How many quotes do I put around it so that it is evaluates with the quotes
within it.

I'm attempting to move this description to another table since this is in a
temporary table.

This is part of the code the SQL code:

strSQL = "TWDESC.DESC = " & rstmp!Desc & ";"

The problem is that rstmp!Desc has the quotes in it:

"REV "D" DATED 03-07-00"

Thanks for your help.

 

[Dirk Goldgar]

I'm not sure how to handle quotes within a string variable.

The variable is: "REV "D" DATED 03-07-00"

The quotes above are part of the literal varibale stored in a field
in a table.

How many quotes do I put around it so that it is evaluates with the
quotes within it.

I'm attempting to move this description to another table since this
is in a temporary table.

This is part of the code the SQL code:

strSQL = "TWDESC.DESC = " & rstmp!Desc & ";"

The problem is that rstmp!Desc has the quotes in it:

"REV "D" DATED 03-07-00"

Thanks for your help.

You need to get the string value enclosed in quotes, plus you need to
double-up each embedded quote in the string. Try this:

strSQL = "TWDESC.DESC = " & _
Chr(34) & _
Replace(rstmp!Desc, Chr(34), Chr(34) & Chr(34)) & _
& Chr(34) & _
";"