Re: MS SQL - Syntax error for valid query

["AWFrueh1808" <webforumsuser@xxxxxxxxxxxxxx>]

OK, that's simple enough.  But then I'm really confused as to why the query in 
my original post/example didn't work.  

 The only single quotes in my #whereClause# variable were wrapped around each 
varchar value in the WHERE clause (well, HAVING) as in HAVING formNum = '12345' 
OR formNum = '54321'

 I never used a single quote within the value itself.  And yet 
preservesinglequotes fixed it.  So what was CF doing?  Why did the single 
quotes still show up in the error msg - and in the right place?