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.

 

[Rick B]

NewField: Left([CurrentFieldName],8)

 

[Guest]

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.