Re: SQL LIKE statement to text field fomr CF MX 6.1

["Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>]

The sql works the same no matter how large the string is.  The part between the 
percentage sign has to be matched exactly.  If you are only getting a match 
sometimes, then something is different with your test string.  It could be a 
capital letter somewhere, or some extra whitespace.

 I rarely work with SQL Server so I don't know it that well.  However, I'm 
pretty sure it has upper and lower functions.  That will help you with the 
capital letter problem.

 The whitespace problem is harder.