Subject | Re: [Firebird-general] Line jump in a field |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-05-27T11:11:25Z |
Hello Fabrice,
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
> Does it exist a tips to find a line jump (char = 13) in a fieldTry
> (Blob or VARCHAR) with a SQL query without use of UDF ?
>
> Something like :
> select * from customer where adress containing #13
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