PHONE NUMBERS UPDATE

I am trying to update a table call "SALES".
The column name is call "PHONE"
The phone numbers are in these formate==> (AAA)BBB - CCCC
(AAA) is the area code.
BBB is the set of numbers following the area code.
CCCC represent the last four numbers.

I need to update the BBB to ZZZ in order for my phone number to look like this
(AAA) - ZZZ-CCCC

Please help.

UPDATE t
SET Phone = SUBSTRING(Phone, 1, 5)+'ZZZ'+SUBSTRING(Phone, 9, 6)
WHERE SUBSTRING(Phone, 6, 3) = 'BBB'

- HTH -
------------
Marshall at 8/16/01 8:42:17 PM


I am trying to update a table call "SALES".
The column name is call "PHONE"
The phone numbers are in these formate==> (AAA)BBB - CCCC
(AAA) is the area code.
BBB is the set of numbers following the area code.
CCCC represent the last four numbers.

I need to update the BBB to ZZZ in order for my phone number to look like this
(AAA) - ZZZ-CCCC

Please help.