Length of field in where condition

[Former Member]

Hi,

I'm trying to retrieve from a table only the records for which a certain field has a certain length.

I tried to use

SELECT .... Where STRLEN <field> = <value> 

but I get a syntax error.

I do not want to retrieve everything and then exclude the records I do not need.

Any solution short of using native SQL, that would allow me to achieve my requirement as stated at the beginning of the message ?

Regards,

Mihai

[Former Member]

I found out .

I have to use like and '_' for 1 character '__' for 2 characters and so on.

Actually the answer was here on SDN as well, but there seems not to be a way to cancel a question.