How to find out the number of digits?

[metad]

Hi. I have an excel document witch I transfer to a new table in MS Access 2000. The transfer sheet includes a column for time without column (e.g. 1900). If the time is 0500 the transferred data shows 500. I have made a query bases on this table and I am able to fine the left and right digits in the field and convert it to the time format as 19:00, but I have problems with 3 digits transferred data like 500. When I convert this to the time format it shows 50:00. I can define an If statement for converting if I can find out how many digits the transferred data has.

So, my question is how to find out the number of digits in a field in a query?

Thanks in advance.
Regards,
metad

 

[matteobo]

Help!!!

Please, someone can help it's really important I don't know sql language so I have to do this by dos...
please...