Jim,

I do enough building of SQL Pass-through strings that I've taken to using them by default. Example:

cSQLPassThrough = [SELECT * FROM MyTable ] + ;
[WHERE MyField = "Adam's Apple" ]

Try doing that one with quotes. It gets ugly.


>Thanks Larry (and Ko),
>
>I guess I didn't search for "square brackets" in MSDN.
>
>Interestingly, when I searched on "Creating Character Expressions" it came up way down in the list.
>
>Anyway, I now KNOW that I can freely use square brackets in lieu of quotes.
>
>Cheers,
>
>JimN
>
>>>Hi all,
>>>
>>>A while back, when getting into WebConnect, I found liberal use of square brackets where I had expected to see quotes (single or double). I knew these substituted nicely for parentheses in array coding but was totally surprised by this other usage.
>>>
>>>I've played around with these a bit and find them (square brackets) equivalent to quotes of either variety.
>>>
>>>Is this a correct conclusion?. . . Is this documented somewhere (a search of MSDN (July 2000) and Hacker's revealed virtually nothing)? . . . Are there things to watch out for?
>>>
>>>Thanks for any comments,
>>>
>>>JimN
>>
>>Jim,
>>I only found one mention of it. Search on
>>
>>"Creating Character Expressions"
>>
>>It is mentioned as a way of including single or double quotes in a string literal.