extracting from middle of string

[sem1604]

I'm attempting to extract a similar string from a linked table the text I'm trying to extract is SPEC #### (this is always 9 characters long including the space), the entry can appear at various positions within the string but is always in the same format.


Ive tried searching this forum and attempted a few solutions I though might apply and as yet had no success.

Many Thanks
Steven

[isladogs]

Try this in your query

Mid(Description, InStr(Description,"SPEC"),9)

[sem1604]

Thanks very much - worked a treat.

[isladogs]

Excellent. Please mark as Solved using the Thread Tools dropdown