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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only