Have a look in vba help for INSTR and MID

--
Don Guillett
SalesAid Software

"Abdul" wrote in message
oups.com...
Hi All,

Is it possible to get part of data in a field using query?

I have a filed for which the number of characters is not fixed containg
data in the format xxxx/xxxxxxx

I want to get only the right side of the "/" only in a field. The
number of characters after "/" is not fixed.

Any help please?

thanks