>>How can I use the REPLACE command with a field that contains an apostrophe in it? For example, REPLACE cPrefix WITH "Women's Hospital, Flint" WHERE blah, blah ...
>>
>>thanks
>
>I tried that command just now and it worked. If you surround it with double quotes it should work. What error are you getting?
If the intent is to replace the field with exactly "Women's Hospital, Flint", trying putting it into a variable, like this
repstr = '"Women'+"'s Hospital, Flint"+'"'
Mike
"I can live with doubt and uncertainty and not knowing. I think it is much more interesting to live not knowing than to have answers that might be wrong." - Richard Feynman