Case insensitive LIKE search

[Ruslan Zasukhin]

On 12/14/05 6:11 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:

Hi Dave,
 
> 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)?

But if you have assign or db Strength to be Primary,
then LIKE respect this of course!

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]