Re: Case Insesitive search (how)
That's how we do it on IDS 7.22:
SELECT * FROM table
WHERE field MATCHES "*[Tt][Hh][Ii][Ss] [Ii][Ss][Aa]*";
Richard Krenek wrote:
> Hello all,
> How do I do a case insesitive search. Lets say I have a field "This
> Is A Test", I would like to seach for it using "this is a", (SELECT *
> FROM table WHERE field LIKE '%this is a%' ) does not work. Any ideas?
>
> Richard Krenek