SQL update statement to change integer to have a 1 in front of it?

Question

SQL update statement to change integer to have a 1 in front of it?

Answer 1

concatenate it with the '1' + pk query

sample



UPDATE table name

SET column name = '1' + num

WHERE conditions



hope this helps

Answer 2

UPDATE table SET decimalField='0' WHERE decimalField=NULL

Answer 3

update YourTable

set id = cast('1'+cast(id as varchar) as int)

Answer 4

Depends on whether ID is defined as a number or as varchar. If a number and all the existing values are less than 1000, it's pretty simple



UPDATE someTable SET ID = ID + 1000



If it's varchar, syntax will be DBMS dependent but likely one of the following



UPDATE someTable SET ID = '1' + ID

UPDATE someTable SET ID = '1' || ID

UPDATE someTable SET ID = CONCAT('1,' ID)



Note that irregardless of the type and DBMS, if the column is used as a foreign key in other tables, you will not be able to change the value unless the referential integrity rule is set to UPDATE CASCADE.

Answer 5

UPDATE table_name SET column_name='1300', '1100', '1400', '1123', '1540' WHERE column_name='300', '100', '400', '123', '540';

Answer 6

Try to run the following code:



update [table name]

set [column name] = '1'+[column name]

where [condition if any]