Subject | Re: [firebird-support] Length of String < 10 in SQL Statement - how? |
---|---|
Author | Magnus Titho |
Post date | 2005-01-27T08:21:49Z |
hi_feroz schrieb am 27.01.2005 09:08:
select Column from Table
where substring(Column from 10 for 1) = ''
:-)
Magnus
>The dirty solution (no UDF needed):
> hi huyz,
> how to write select statement to fecth the records where the length
> of value of a string field is < 10?
select Column from Table
where substring(Column from 10 for 1) = ''
:-)
Magnus