How to add double quote (i.e. ") in a string

[Doraemon]

I would like to ask is it possible to add double quote in a string.

Since when assigning value to a string variable, we have to use double quote to quote the text, so I wonder a double quote can be included in the text, so that double quote can be displayed.

Thank for your help in advance.

 

[redapples]

try adding

 & Chr$(34) &

where you want the double quote to appear

Redapples

Want the best answers? See FAQ181-2886

 

[JimInKS]

Just use double double quotes ("&quot everywhere you want a single double quote, for instance:

If you want to produce a SQL string that looks like this:
SELECT * FROM mytable WHERE LastName="smith";

Then the code might look like:
strSQL = "SELECT * FROM mytable WHERE LastName=""smith"";"

or you might do something like this:
strFilter = 'smith'
strSQL = "SELECT * FROM mytable WHERE LastName=""" & strFilter & """;"