stripping the most significant digit from the number 2

[robojeff]

I have a table which contains a number field and I need to append a field to that table with a value based upon the number stored in the number field.

What I need to do is take the most significant digit of this number (it will be either a two digit number or a three digit number)and multiply that number by 10
and store the result in my new appended field. Another gotcha is that the number could be zero in which case I would want to store a zero
in the appended field...

in other words, my table would contain the number field below and I would like to append the new field as shown below:

number field new field
310 30
150 10
84 80
440 40
0 0

How can I strip the most significant digit from the number field with a query?

thanks

 

[PHV]

A starting point:

SELECT Val(Left([number field],1) & '0') AS [new field]
FROM yourTable

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

How About

left(YourNumberfield,1)*10

 

[robojeff]

Thank you both...