On 9 Oct 2003 at 15:14, Thomas Rьger wrote:

>I have a database with one table, one field. Field is a varchar 255.
>I now want every entry with a length over 250, but:
>Select * from tablename where length(feld2) > 250
>isn't working.
>
>how can i get with a sql every entry with more then 250 characters....

UDF was already suggested, but I'd like to offer "plain SQL"
solution: use LIKE with a pattern consists 251 underscore and percent
sign.
Much shorter example - values longer than 5 chars:

select * from tablename where field2 like '______%'

SY, Dimitry Sibiryakov.