need a query to look for specific num of bytes in a field

R

randall

I have a field in an access table which contains records of varying lengths
anywhere from 2 to 30 bytes. I need a query to select records with, say 16
bytes only, or whatever length I need
 
M

mscertified

tables contain columns not records. do you mean the data in the column is
variable length?
Try:-
SELECT ......
FROM ......
WHERE LEN(myColumn) <= 10;

Dorian
 
Top