Field lenght

[Guest]

Hello all
I want to select those records that have a length of less than 2 in FiledA.
Anyone can help me?

 

[Rick Brandt]

Hello all
I want to select those records that have a length of less than 2 in
FiledA. Anyone can help me?

SELECT *
FROM TableName
WHERE Len([FieldA]) < 2