求助

Question

2002感动夺取这是一条ACCESS记录的字段值,我想在2002后加个回车
变成这样 
2002
感动夺取

Answer 1

declare @str1 varchar(500)
        ,@str2 varchar(500)
        ,@str varchar(500)
select @str1 = '2002'
select @str2 = '感动夺取'
select @str = @str1 + char(10)+char(13) + @str2
select @str----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2002
感??取(1 個資料列受到影響)

Answer 2

declare @S varchar(50)
set @s='2002感动夺取'
select stuff(@s,5,0,char(10))