>>>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"+'"'
That's not very clear is it -
"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