Working with Text

[Artemis]

I am trying to create a query that will select a piece of text that always appears after another piece text eg:

Request for manufacturers RMA Number sent to Zebra. RMA No: 318937

The words RMA No: are standard in every record. I want to display the following 12 characters the follow after.

The characters always follow the 'RMA No: statement.

The text appears in an a table 'Details'

Grateful for any help you can offer.

 

[pbaldy]

Check out the Mid() function in help.

 

[Brianwarnock]

He may need to check out Instr as well.

Brian