Finding RETURN through search query in V14MD

[Florian Bogeschdorfer]

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

AH OK, thank you. COuld not find that in the docs.
Yes V1 has a contains search. Actually every LIKE search is a contains
search.

LIKE 'a' results in "adam","a","ban" etc...

Thank you, FLorian