Fabrice Vendé wrote:

> Hi !
>
> Does it exist a tips to find a line jump (char = 13) in a field (Blob or
> VARCHAR) with a SQL query without use of UDF ?
>
> Something like :
> select * from customer where adress containing #13

If you can do parametrized query (i.e. you query from code), you can use
parameter

select * from customer where adress containing ?

And set it's value to a newline.

M.