Find and Replace

[Toan]

Hi all!

I have a database that keeps a record of how many payments
our collectors gets per day. They data that is entered
would look something like this...

CGE 1 6/16/04
BDM 5 6/16/04
CGE 4 6/17/04
BDM 2 6/17/04

Where the first column is the user's ID, the second is the
payment they got, and the third is the date.

One of our user recently got married and wants her name
change to BDE instead of BDM.

How can I change all of the BDM entries to BDE?

A thousand thanks in advance!

 

[Dave Venus]

Hi!

Try an update query something like this:

update <table name>
set <name/user id> column = "BDE"
where <name/user id> column = "BDM"

Cheers!

Dave Venus