string concatenation

Hi,

How do I concatenate the following strings?
SELECT A FILE FROM
"XXXXXXX"
ANYTHING HERE

I want the resulting string to be:
 resultingStr = SELECT A FILE FROM "XXXXXXX" ANYTHING HERE

The problem is the "XXXXXX".  I have to include the quotation marks.

Thanks
gamestorsAsked:
Who is Participating?
 
tureConnect With a Mentor Commented:
gamestors,

resultingStr = "SELECT A FILE FROM" & CHR(34) & "XXXXXX" & CHR(34) & "ANYTHING HERE"

Ture Magnusson
Karlstad, Sweden
0
 
gamestorsAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.