An old bug involving the use of complex string functions inside of queries with values having single quotes has been fixed!

http://www.macromedia.com/support/coldfusion/ts/documents/quotes_hotfix.htm