Monday, 26 August 2013

hey anyone can help me about sql systax replace

hey anyone can help me about sql systax replace References this is sql code UPDATE [Customers] SET [Address] = REPLACE([Address],\'123456\',\'02\') WHERE [CustomerID] = 4 ============================ this code replace 02 on 123456 but i want to change on 2 first digit is change to 023456 can any one help me Thank

No comments:

Post a Comment