Length(field_name) in Access?

[Rodrigo Flores]

Hi all,

I'm conecting to ODBC to different RDBMSs and have a query in the form:

SELECT COUNT(*) from some_table WHERE LENGTH(some_field) <> established_length;

However, I just discovered that Access 2002 doesn't support this function (LENGTH).

Any clues or ideas on how to accomplish this?
(besides having my program fetching all rows in the table and checking them by hand)

Thanks,
Rodrigo

[Trevor Best]

Rodrigo Flores wrote:

Hi all,

I'm conecting to ODBC to different RDBMSs and have a query in the form:

SELECT COUNT(*) from some_table WHERE LENGTH(some_field) <> established_length;

However, I just discovered that Access 2002 doesn't support this function (LENGTH).

Any clues or ideas on how to accomplish this?
(besides having my program fetching all rows in the table and checking them by hand)

Thanks,
Rodrigo

Use Len()

--
Error reading sig - A)bort R)etry I)nfluence with large hammer