counting stars in field

[boje]

Hey all. I need to know how to select from a field where the total number of chars in the field is less than 5. Anyone with the answer, please reply, thanks a lot in advance for your answers. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[nevada]

Boje
try this
Code;

select foo
from daTable
where char_length(foo) < 5

Giood luck -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --