Extract specific text from a text string

[Taffy]

I want to extract a specific section of text in a [stock_code] using a query.
I assume I would use the Mid and Instr functions but I'm not sure how. The
stock codes vary in length, so I dont think I can use Left/Right functions.
Examples of stock codes are as follows:-

ERT/22344/01
ERT1/2376474/45
RTR13/4665/45SD

I only want to return the data after the first "/"

Your help would be appreciated.

 

[Bob I]

yes you would use Instr Mid and Len functions (Len - Instr = chars to copy)