Subject | Easy Question SQL |
---|---|
Author | Thomas R�ger |
Post date | 2003-10-09T13:14:25Z |
Hello,
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.
Same with:
Select * from tablename where character_length(feld2) > 250
So,
how can i get with a sql every entry with more then 250 characters....
Thanks a lot and
cu
thomas
[Non-text portions of this message have been removed]
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.
Same with:
Select * from tablename where character_length(feld2) > 250
So,
how can i get with a sql every entry with more then 250 characters....
Thanks a lot and
cu
thomas
[Non-text portions of this message have been removed]