SQL LIKE

[jda]

>  > Looking at the latest SQL docs for V2 (p. 24), it seems that LIKE
>>  should be acceptable for searching (equal to REGEX). But it doesn't
>>  work for me. Should it? Or am I misreading the documentation?
>
>It is not such powerful as REGEX,
>
>Show your examples, Jon.
>

Oh, OK. I tried to do a case-insensitive search with

authors LIKE '(?i)ruslan'

and got no hits (worked with REGEX '(?i)ruslan'

I also tried

authors LIKE 'ruslan' no_case and got an error (Table no_case not found).

Maybe the V4RB pdf, which shows an example like this on p. 103, is wrong?

Jon