Replacing a part of the string

[Varsha Vaishnav]

Hello,

I have a variable indicating state of residence. I want to replace And with & when it appears in the middle, for instance, Jammu And Kashmir, Daman And Diu. But when I run

replace state = subinstr(state,"And","&",.)

, it replaces And in other positions as well. For instance, Andhra Pradesh becomes &hra Pradesh. How can I replace just the middle part?

Thank you.

[George Ford]

try putting spaces around it

" And "

but add spaces to " & " to put them back

[Varsha Vaishnav]

Thanks George. It works.