Preceding a number by '0' How to use SQL statement

sunnylan

The field DBBH in the table DBDA in the existing SQL Server database. The value of this field is '5555555'. I want to change the DBBH to '05555555', which is to add a '0' before the DBBH field. How to write this sentence, thank you! !!

van_sin

update table set DBDA = '0' + DBDA

neison

If the field is of type char or varchar, the one upstairs is OK. If it is a number, the type must be converted

stevevai

Ha ha, if it is a number type, ha ha, it is estimated that this work should not be done, because the database is difficult to save such a formatted number

rkpost123

DBBH is an integer:
select right ('0' + cast (DBBH as varchar (10)), 10) as DBBH

lazying

Why are you so strenuous, you just have to add it when you call the data

xiao8342

procedure setzero(var s:string;len:Integer);
var
i: Integer;
begin
  for i:=1 to len-length(s) do
  begin
    s := '0' + s;
  end;
end;

You mean that the length is not enough to fill in '0', right?

abomination

Add 0 to the front of the integer? ?

lonelywenyi

RIGHT(100000000+field name, 8)

jscool

You can convert the value to a character, and then see how many bits there are and add 0 to the front