create table tb1 (c1 varchar(30))goinsert into tb1 select '9607039'goselect * from tb1goupdate tb1 set c1='19'+stuff(c1,5,0,'0')goselect * from tb1godrop table tb1
declare @str varchar(8000) set @str = '9607039' set @str = '19' + left(@str,4) + '0' + right(@str,3) select @str
--使用stuff函数 declare @str varchar(8000) set @str = '9607039' set @str = '19' + stuff(@str,5,0,'0') select @str
(c1 varchar(30))goinsert into tb1
select '9607039'goselect * from tb1goupdate tb1
set c1='19'+stuff(c1,5,0,'0')goselect * from tb1godrop table tb1
set @str = '9607039'
set @str = '19' + left(@str,4) + '0' + right(@str,3)
select @str
declare @str varchar(8000)
set @str = '9607039'
set @str = '19' + stuff(@str,5,0,'0')
select @str