Hi everyone))) Can anybody help me with the SQL task?
We have: telephone’s data type is decimal
Task: Need to replace telephone code from 495 to 499.
UPDATE dbo.Readers SET Contact_telephone = REPLACE(Contact_telephone, 495, 499);
If I do it like this, every single 495 record in
Readers.Contact_telephone will be replaced with 499. This isn’t right
I’ll be very glad if you help me)))