[dba-SQLServer] SQL Nightmares

Arthur Fuller fuller.artful at gmail.com
Thu Mar 20 08:33:04 CDT 2008


It's the double-quotes. All strings in SQL other than column names must be
delimited with single-quotes.

On 3/20/08, Susan Harkins <ssharkins at gmail.com> wrote:
>
> SELECT right("Hello",2) AS TestColumn
>
> ????
>
> Not sure John, but I use Query window to run expressions all the time, so
> I
> know that it does work. :)
>
> Susan H.
>



More information about the dba-SQLServer mailing list