Split Fields

[phuser]

I have a select query that has a text field, I have changed the properties
so the that the data reads right to left, I would like to create a column
that shows only the first 8 digits from that field.

 

[KARL DEWEY]

Right 8 Digits: Right([YourField],8)

 

[phuser]

thank you Both!!

Right 8 Digits: Right([YourField],8)

I have a select query that has a text field, I have changed the
properties
so the that the data reads right to left, I would like to create a column
that shows only the first 8 digits from that field.