SELECT * FROM myTable WHERE myFieldName LIKE 'integer' and length(myFieldName) = 2

[jacques perconte]

Hi all,
is it possible to use the length function in an where clause like this:

SELECT * FROM myTable WHERE myFieldName LIKE 'integer' and
length(myFieldName) = 2

In case of not, is there some other possibility to check the length of an
field in a where clause?

Thanks for your help
Jacques