By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

Length(field_name) in Access?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.