How to pull 1000 characters

[JA]

Is there a way to pull records where one of the fields has 1000 or less
characters?

Thank you,

JA

 

[Immanuel Sibero]

Hi JA

Use a select query with criterion:

Len([SomeField]) <= 1000

Also, consult the help facility regarding Trim, LTrim, and RTrim if leading
or trailing spaces in the field matter to you.

HTH,
Immanuel Sibero

 

[Van T. Dinh]

SELECT *
FROM YourTable
WHERE Len(YourField & "") < 1000