Query of query... 'like' operand error !!!

Today, I happened to be a serious mistake in the use of query or query. I lost half an hour to figure out where the problem was.

A simple query of query like this:

<cfquery name="myQQ" dbtype="query"> select field1 from TBL_MASTER WHERE field2 like ' #myVar#' </ cfquery>

After a half hour test I found that the problem was in the myVar variable that was always compared in a "case sensitive". I had never noticed this detail.

Someone can give me more information?

The system is Win Coldfusion 8 with MS Sql Server 2008