Extracting Characters in a Query

[Guest_imported]

I have an id number 1234567 where 7 is the "check" digit. I need to run a query that has the digits "123456" in one field, and 7 in another. I can get the 7 out, but due to varying id lengths, I can't always get the first digits out. I've tried mixing functions like -- left([id], len([id])- 1) but that doesn't seem to work. Any ideas?

 

[THoey]

Try:

SELECT LEFT(CSTR([ID]), 1, LEN(CSTR([ID])) - 1) AS LeftPart,
RIGHT(CSTR([ID]), 1, 1) AS RightPart
FROM MyTable

Hope that helps... Terry M. Hoey

 

[Guest_imported]

Thank you thank you so much!