Code:
UPDATE tbl_Container SET tbl_Container.Location = Switch(
[WHSE_ID] Like "*A","SP-01",
[WHSE_ID] Like "*B","SP-02",
[WHSE_ID] Like "*C","SP-03",
[WHSE_ID] Like "*D","SP-04",
[WHSE_ID] Like "*E","SP-05",
[WHSE_ID] Like "*F","SP-06",
[WHSE_ID] Like "*G","SP-07",
[WHSE_ID] Like "*H","SP-08",
[WHSE_ID] Like "*I","SP-09",
[WHSE_ID] Like "*J","SP-10",
[WHSE_ID] Like "*K","BUILD PAD (SP-11)",
[WHSE_ID] Like "*L","BUILD PAD (SP-12)",
[WHSE_ID] Like "*M","SP-13",
[WHSE_ID] Like "A*","A-Pad",
[WHSE_ID] Like "B*","B-Pad",
[WHSE_ID] Like "C*","C-Pad",
[WHSE_ID] Like "D*","D-Pad",
[WHSE_ID] Like "E*","E-Pad",
[WHSE_ID] Like "P*","P-Pad",
[WHSE_ID] Like "F*","F-Pad",
[WHSE_ID] Like "Q*","Q-Pad",
[WHSE_ID] Like "G*","G-Pad",
[WHSE_ID] Like "H*","H-Pad",
[WHSE_ID] Like "R*","R-Pad",
[WHSE_ID] Like "I*","I-Pad",
[WHSE_ID] Like "J*","J-Pad",
[WHSE_ID] Like "K*","K-Pad",
[WHSE_ID] Like "L*","L-Pad",
[WHSE_ID] Like "M*","M-Pad",
[WHSE_ID] Like "S*","S-Pad",
[WHSE_ID] Like "N*","N-Pad",
[WHSE_ID] Like "X*","X-Pad",
[WHSE_ID] Like "T*","T-Pad",
[WHSE_ID] Like "Y*","Y-Pad",
[WHSE_ID] Like "MR-01","MR-01",
[WHSE_ID] Like "MR-02","MR-02",
[WHSE_ID] Like "MR-03","MR-03",
[WHSE_ID] Like "MR-04","MR-04",
[WHSE_ID] Like "MR-05","MR-05",
[WHSE_ID] Like "MR-06","MR-06",
[WHSE_ID] Like "MR-07","MR-07",
[WHSE_ID] Like "MR-08","MR-08",
[WHSE_ID] Like "MR-09","MR-09",
[WHSE_ID] Like "MR-10","MR-10",
[WHSE_ID] Like "MR-11","MR-11",
[WHSE_ID] Like "MR-12","MR-12",
[WHSE_ID] Like "MR-13","MR-13",
[WHSE_ID] Like "MR-14","MR-14",
[WHSE_ID] Like "MR-15","MR-15",
[WHSE_ID] Like "MR-16","MR-16",
[WHSE_ID] Like "MR-17","MR-17",
[WHSE_ID] Like "MR-18","MR-18",
[WHSE_ID] Like "MR-19","MR-19",
[WHSE_ID] Like "MR-20","MR-20",
[WHSE_ID] Like "MR-21","MR-21",
[WHSE_ID] Like "SURV*","SURV",
[WHSE_ID] Like "TARF*","TARF",
[WHSE_ID] Like "TARF2","TARF2",
[WHSE_ID] Like "ASP","ASP",
[WHSE_ID] Like "TSA","TSA")
Code:
UPDATE tbl_Container SET tbl_Container.Location = Switch(
[WHSE_ID] Like "*A","SP-01",
[WHSE_ID] Like "*B","SP-02",
[WHSE_ID] Like "*C","SP-03",
[WHSE_ID] Like "*D","SP-04",
[WHSE_ID] Like "*E","SP-05",
[WHSE_ID] Like "*F","SP-06",
[WHSE_ID] Like "*G","SP-07",
[WHSE_ID] Like "*H","SP-08",
[WHSE_ID] Like "*I","SP-09",
[WHSE_ID] Like "*J","SP-10",
[WHSE_ID] Like "*K","BUILD PAD (SP-11)",
[WHSE_ID] Like "*L","BUILD PAD (SP-12)",
[WHSE_ID] Like "*M","SP-13",
[WHSE_ID] Like "A*","A-Pad")
WHERE (((tbl_Container.Location)=""))
Is there a workaround to accomplish this?