CF double quoting my single quotes in query string

[lerxst3]

I'm building my query string on the fly. So I have something like this:
<cfset szQuery = "SELECT id FROM tblFoo WHERE id=' " &
#Trim(evaluate(szVarName))# & " ' ">
(I've added a few extra blank spaces to improve readability).
When I do a <cfoutput> of my string, it looks correct. I get:

SELECT id FROM tblFOO WHERE id='5'

However, I get an error running it, and apparently SQL server sees this:

SELECT id FROM tblFOO WHERE id=''5'' (CF adds another single quote - so
it's really two single quotes, not the " character)

Why is CF double quoting my single quote? It's causing me to fail. If I
don't single quote at all, CF doesn't put anything there so my statement simply
becomes: id=5.

[Dan Bracuk]

The preservesinglequotes function will help you out. Details are in the cfml
reference manual. If you don't have one, the internet does.

For my curiousity, why is your id field text instead of numeric?