[dba-SQLServer] Diving off the deep end

Arthur Fuller fuller.artful at gmail.com
Thu Mar 20 08:14:15 CDT 2008


First problem is the double quotes, which SQL interprets as a reference to a
column. Second problem is that the statement must begin with the word
SELECT. After that you're good to go:

SELECT Right( 'John W. Colby', 3 )
==> 'lby'

Third issue: don't compile the query. Just run it.

hth,
A.

On 3/20/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> I THINK THAT WE NEED TO BACK UP A FEW STEPS.
>



More information about the dba-SQLServer mailing list