Re: MS SQL - Syntax error for valid query

["AWFrueh1808" <webforumsuser@xxxxxxxxxxxxxx>]

I guess I'm thick today.

 What confuses me is that the error code SHOWS the single quote.  And if I 
CFOUTPUT my variable, it also still shows the quote.  I don't understand why I 
can CFOUTPUT the variable and see the single quotes just fine - it's not been 
escaped from what I can tell - the variable just doesn't work in a CFQUERY.  
That's what really threw me.