Is there a way to extract digits from a number using a SQL statement? I want
to extract the first digit, second digit etc. from a number. I am using SQL
on an Excel table. In VBA I can do it by casting a number as text and then
pulling the digits out of the character string.

Thanks and Happy New Year,

Dave