>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 ...

Personnally, I like to use brackets whenever quotation marks may be an issue.

REPLACE cPrefix WITH [Women's Hospital, Flint]

Doug