How to add a character
I have a table like this:
Item Code
A 123456
B 123455
C 23457
D 开发者_JS百科 123458
E 23459
F
The Code
column must have 6 characters and I need to add '1' (for example, 23455
to 123455
) for those items with less than 6 characters.
How can I do it with SQL ?
Thanks,
Update table
set Code = CONCAT( '1', TRIM( Code ) )
where LEN( TRIM( CODE ) ) < 6
For SQL Server and assuming the Code column is a character data type, you can do the following
UPDATE myTable
SET Code = '1' + Code
WHERE LEN(Code) < 6
精彩评论