Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by albertp
-
CONDITIONAL UPDATE
UPDATE CUSTOMERS (DIST_CODE, PACKING_NUM) VALUES 'HERE IS WHERE I AM LOST IF COUNTY = 'WY' THEN DIST_CODE = A1 AND PACKING_NUM = 8 IF COUNTY = 'SG' THEN DIST_CODE = A2 AND PACKING_NUM = 9 IF COUNTY = 'DG' THEN DIST_CODE = A3 AND PACKING_NUM = 10 Do this: Update Customers set Dist_Code = A1...- albertp
- Post #6
- Forum: Microsoft SQL Server: Programming
-
SQL UPDATE using a variable
I would like to update a field in an Access table using the SQL update command. The following syntax will work if I want to update a specific value in a field. UPDATE CustomerTable SET City = Atlanta Where Zipcode = 30303 Could anyone tell me the correct syntax to set city = a variable like...- albertp
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
