insert data at the start in a field already created in sql

Question

Navigation

#1 by (2 votes)

0

can help me by indicating how the data update is done at the beginning of a field already created in SQL, for example:

telefono 323890988 247639087

For the fields of the telephone table I need to add at the beginning of each of them the value 012, remaining:

012323890988 012247639087

Keep in mind that there are millions of data to update.

Thank you very much.

sql

asked by PABLO ALVAREZ 31.05.2018 в 03:25

source

1 answer

Obtain a parameter by means of a querystring Header navigation style

score 2 · Answer 1

UPDATE tabla SET [columna] = '012' + RTRIM([columna])

We use the chain concatenation operator to add the value "012" to the beginning of the chain and RTRIM to get the value of the string without spaces.

Do not forget to use a WHERE if it applies