cfquery - single quotes become doubled

Hello all, I am having a strange problem with a cfquery through SQL Server where I am building the SQL statement dynamically from form input. I wonder if anyone here has encountered and over come a similar error in the past, and could lead me toward a solution. When the SQL statement is

Re: cfquery - single quotes become doubled

Thanks all, PreserveSingleQuotes() solved the problem. That's by design. ColdFusion is escaping your single quotes. You need to either wrap your string in the PreserveSingleQuotes() function or, better, use cfqueryparam ~|