use compare
go
/*insert into dbo.swzgtest
select left([列 0],len([列 0])-10), right([列 0],10)

from dbo.xzsanyou8899
*/