get number of digits

[Knowlton]

I need to get the number of digits in a variable number that may have anywhere from 3 to 6 digits. How do I find this?
Thanks!

[Stewart Ross]

Assuming that you are using an MS Access query and you are wanting to find the number of digits in a positive whole-number field, you can use the string function Len() to return the 'length' of the number as follows:

SELECT Len([Your Field Name Goes Here]) as Digits FROM YourTable;

Example of the use of Len() on the Inventory on Hold query of Northwind 2007:

Quantity On Hold  Digits
        25        2
        23        2
       325        3
       110        3
        20        2
        75        2

The SQL for this is just

SELECT [Quantity On Hold], Len([Quantity On Hold]) AS Digits
FROM [Inventory on Hold];

-Stewart

[Knowlton]

Thanks for your reply! I figured out to use the Length function after posting the question.