Length of field in where condition
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 ?