Say I bring up a result

select * from mytable

Location, Name

Atlanta John
Miami Mike
DC Kathy

etc

Is there a way to say, after this query executes (or even within this query), if name=something, rename Location field to something else? Thanks

Are you talking about an Update to the table or a change for a report say?

Brian

Update to the table

Then it is a simple update query, your updateto for the location will be an IIf

Brian