Extract one string from another

[Leslie Isaacs]

Hello

Is it possible to extract one string from another - so for e.g. if stringA =
"This is a string" and stringB = "is a" then the expression to extract
stingB from StringA should return "This string".

I would be very grateful if anyone could help me with this.

Many thanks
Leslie Isaacs

 

[Guest]

Hi,
have a look at the Instr function.
Here is some info:
http://www.techonthenet.com/access/functions/string/instr.php
HTH
Good luck

 

[John Spencer]

Use Replace function in later versions of Access.

In earlier versions, 97 and some of 2000, you'll need to write a VBA
function or use instr, len, mid functions to do this.