LEFT() problems

[turtle]

I need to get the right end of a field. Really what i want is
everything after 7 characters in.

so if the field is 123456789
i would return 89

I can't use right([field]) since i don't know how many characters the
field will be.

any help

tia,
KO

[lyle fairfield]

turtle <ko****@vistacontrols.comwrote in news:f722ab6f-ae0e-4d07-85dd-
68**********@u69g2000hse.googlegroups.com:

so if the field is 123456789
i would return 89

Mid$("123456789", 8)

[Larry Linson]

You can use the Len function to return the length of the original string,
subtract 7 from it, and use that as the length field of a Right command, but
Lyle's approach is simpler, and likely faster (though any code execution is
likely to be so much faster than disk operations that shaving a few
nanoseconds or microseconds isn't going to make a visible difference to the
user watching the screen.

Larry Linson
Microsoft Office Access MVP

"turtle" <ko****@vistacontrols.comwrote in message
news:f7**********************************@u69g2000 hse.googlegroups.com...

>I need to get the right end of a field. Really what i want is
everything after 7 characters in.

so if the field is 123456789
i would return 89

I can't use right([field]) since i don't know how many characters the
field will be.

any help

tia,
KO

[DFS]

turtle wrote:

I need to get the right end of a field. Really what i want is
everything after 7 characters in.

so if the field is 123456789
i would return 89

SELECT Mid(Field,8) as Remainder
FROM Table

I can't use right([field]) since i don't know how many characters the
field will be.

any help

tia,
KO