Case insensitive LIKE search

[Dave Addey]

Is it possible to do a case insensitive SQL Select without having to use
Regex?  Like the old no_case modifer.

Or, even better, is it possible for my LIKE match to respect the value of
kStrength I have assigned (kPrimary)?

Dave.