Finding RETURN through search query in V14MD

[Ruslan Zasukhin]

On 11/21/06 12:20 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian,

> HI all!
> 
> I am looking for a way of how to escape a RETURN character in the SQL
> search. I want to find all records where myField contains a RETURN.
> How?

Try

    WHERE fld LIKE '\r'

Not remember if v1 have CONTAINS search.

    WHERE substr( fld, "\r" ) > 0

This should be used as method of course for v1


-- 
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]