How to get the last 6 of a field?

[dndaughtery]

I have a field that I need to get the last 6 digits of. How can I do this?

 

[MDXer]

try

Select
Right(mycolumn, 6)
From MyTable

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[earthandfire]

You say digits - if its an integer field then you could use

select myfield % 1000000


Hope this helps