Escaping single quotes in cfquery

how many ways can we escape the single quotes while using cfquery.

three

My favorite use is PreserveSingleQuotes(). It’s a built-in function of recent ColdFusions that ensures that single quotes aren’t auto-escaped.

thanks