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. >