CustomerName |
---|
MIKES AUTO REFINISHING (C60) |
MIKES AUTO REFINISHING (C60) |
CALIBER - GLENOLDEN #3709 (W60) |
MOPPERT BROTHERS AUTO COL |
CALIBER - GLENOLDEN #3709 (W60) |
KEN STOCKER AUTO BODY |
BUCKINGHAM COLLISION & TOWING SERVI |
BUCKINGHAM COLLISION & TOWING SERVI |
BUCKINGHAM COLLISION & TOWING SERVI |
MAACO BRIDGEPORT (W60) |
MAACO BRIDGEPORT (W60) |
CustomerName |
---|
MIKES AUTO REFINISHING |
MIKES AUTO REFINISHING |
CALIBER - GLENOLDEN #3709 |
MOPPERT BROTHERS AUTO COL |
CALIBER - GLENOLDEN #3709 |
KEN STOCKER AUTO BODY |
BUCKINGHAM COLLISION & TOWING SERVI |
BUCKINGHAM COLLISION & TOWING SERVI |
BUCKINGHAM COLLISION & TOWING SERVI |
MAACO BRIDGEPORT |
MAACO BRIDGEPORT |
UPDATE Table1
SET Table1.CustomerName = Trim(Left([CustomerName],InStr([CustomerName],"(")-1))
WHERE InStr([CustomerName],"(")>0;