What Character?

[Mr. JYC]

Hello,

When I am generating a SQL statement to be used in programming, what
character should I use for " for instance,

select stores from mall where stores like "Sears*";

I am trying to build a string from the above statement but I don't know what
to use for the " character.

So, the statement would look like

str = "select stores from mall where stores like" & Sears*

but I am stuck with what to use for what to put around Sears* so that the
SQL statement would execute properly.

Please help.

 

[tina]

"SELECT stores FROM mall WHERE stores LIKE 'Sears*'"

if you're referring to a control on a form, rather than a hard-coded value,
the syntax would be

"SELECT stores FROM mall WHERE stores LIKE '" _
& Me!ControlName & "*'"

hth

 

[Allen Browne]

Quotes inside quotes must be doubled, so:
strSQL = "select stores from mall where stores like ""Sears*"";"

For an explanation, see:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html