Nice. We had already changed the code but that is good to know.

>You can use single or double quotes to fix this problem. My guess would be that SQL Select parser doesn't process string encloused in [] delimiters properly

>Select ;
>     "a?b" as Url ;
>   From < table >
>* or
>Select ;
>     'a?b' as Url ;
>   From < table >
>

>
>>On of our SQL statements has a field which contains a "?".
>>
>>I ran a simple test.
>>
>>

>>Select ;
>>     [a?b] as Url ;
>>   From < table >
>>

>>
>>The question mark disappears. Below fixes the problem.
>>
>>

>>Select ;
>>     [a] + Chr(63) + [b] as Url ;
>>   From < table >
>>

>>
>>I'm betting this has been documented already. What is the reason for this behavior?
>>
>>TIA