Subject Re: [Firebird-general] Line jump in a field
Author Paul Vinkenoog
Hello Fabrice,

> 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

Try

select * from customer where adress containing '
'

ie use a REAL newline. It may seem silly, but this is the way to do it
for inserts and updates. So it might work in a where clause too...


Greetings,
Paul Vinkenoog