I have some tables in SQL and I want to add two digit (the two digit is a fixed number that is 13 ) to the first of all numbers in a some columns. I used this script but unfortunately it doesn't work accurately:
for example I want to change 991105 to 13991105.
my script is as follow:
UPDATE tblOrder SET tblOrder.DateReceived = 13 & [DateReceived]