Subject Re: [firebird-support] Length of String < 10 in SQL Statement - how?
Author Magnus Titho
hi_feroz schrieb am 27.01.2005 09:08:
>
> hi huyz,
> how to write select statement to fecth the records where the length
> of value of a string field is < 10?

The dirty solution (no UDF needed):

select Column from Table
where substring(Column from 10 for 1) = ''

:-)



Magnus