Re: I need to change all data in two fields
- From: MGFoster <me@xxxxxxxxxxx>
- Date: Tue, 28 Feb 2006 20:34:32 GMT
JanineB wrote:
I have a table holding all of our customers information. Two of the fields are SocialSecuityNumber and DateOfBirth. For all 2500 customers, I need to set the SS# to 000000000 and the DateOfBirth to 25413. Can you tell me how to do this?
UPDATE table_name
SET SocialSecurityNumber = '000000000',
DateofBirth = 24513
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.
- Prev by Date: Re: expressions to omit info
- Next by Date: Re: select from a combo box to display a report
- Previous by thread: Re: I need to change all data in two fields
- Next by thread: Work Around
- Index(es):
