SQL State to select feilds of certain length

[ukgimp]

Hello

Trying to select only fields of a certain length ( less than 2, or = 1 or 0)

Any ideas

SELECT * FROM table WHERE LENGTH(Feild) < 2;

Does not seem to wordk and I can for the life of me find an online example.

Cheers

[ukgimp]

Solution :)

SELECT * FROM table WHERE LEN(Feild) < 2;