how to make string containing " ?

[bob]

Hi,

I need to make a string containing this text litterally as it::
selectcommand="select * from table where field1=' " & myvar & " ' "

Dim st as string
st="selectcommand=" & ???

How can i include " in the string without it is interpreting as a string
delimiter?

Thanks
bob

 

[Miro]

have you tried to use the char value?

 

[bob]

I foun dit:
just double " in the string

have you tried to use the char value?

 

[Steve Long]

Bob,
I think the standard way to do this is:
& Char(66)

 

[Peter Macej]

I foun dit:

just double " in the string

Yes, "" is an escape sequence for " in VB strings. I wrote a macro that
allows you pasting any text (even very long multi-line) as VB string:
http://www.helixoft.com/blog/archives/12

 

[GhostInAK [Bastard]]

Hello Steve,

I believe you mean 34.

-Boo

Bob,
I think the standard way to do this is:
& Char(66)

 

[Smokey Grindle]

double quotes

selectcommand="select * from table where field1=""" & myval & """

 

[Steve Long]

Opps.

Hello Steve,

I believe you mean 34.

-Boo