Why has different output of function replace?

Question

declare @tachareName varchar(200)
        ,@a varchar
set @tachareName='fsfhk,fsif,'
if(CHARINDEX(',',@tachareName)!=0)              
    --print @tachareName
    --select REPLACE(@tachareName,',',' ')--The output is:fsfhk fsif 
    set @a=REPLACE(@tachareName,',',' ')
    --REPLACE(@tachareName,',',' ')
    print @a    --The output is:f

What's wrong,i want to judge if the string has ',' symbal and repalce it with ' '.

The envirioment is SQL Server 2008.

gzaxx · Accepted Answer · 2013-11-06 09:29:27Z

2

Because of your declaration of @a - you have not declared length of variable so it defaulted to 1. Thus returning only the first letter of result.

Declare @a as:

declare @a varchar(200)

Read more about char and varchar declaration on MSDN.

answered Nov 6, 2013 at 9:29

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Don Over a year ago

There's a suggestion to change this very thing on Microsoft Connect

Collectives™ on Stack Overflow

Why has different output of function replace?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related