Re: What Character?
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Tue, 30 Sep 2008 02:57:27 GMT
"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
"Mr. JYC" <MrJYC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:98610DA7-CA10-45F3-8934-CCF263DA9106@xxxxxxxxxxxxxxxx
Hello,what
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
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.
--
Thank you for your help!
JYC
.
- References:
- What Character?
- From: Mr. JYC
- What Character?
- Prev by Date: Re: DLookup too soon after record insert?
- Next by Date: Re: sum unique records with multiple fields
- Previous by thread: What Character?
- Index(es):
Relevant Pages
|
