Replace

[qhjghz]

Hi all,
I have read about the REPLACE function and it seems alright. But, can anyone tell me what the following piece of code does?

select @a='DebasisDas'
select @a=REPLACE(@a,c har(10),'b')

I don't find any differences

[ak1dnar]

Hi all,
I have read about the REPLACE function and it seems alright. But, can anyone tell me what the following piece of code does?

select @a='DebasisDas'
select @a=REPLACE(@a,c har(10),'b')

I don't find any differences

This may help out for you. read here

[azimmer]

Hi all,
I have read about the REPLACE function and it seems alright. But, can anyone tell me what the following piece of code does?

select @a='DebasisDas'
select @a=REPLACE(@a,c har(10),'b')

I don't find any differences

It would replace LineFeeds to 'b' but as there are none in the string it simply returns it unchanged. Try this and you'll see changes:

declare @a as varchar(20)
select @a='DebasisDas'
select @a
select @a=REPLACE(@a,char(68),'b')
select @a

[qhjghz]

It would replace LineFeeds to 'b' but as there are none in the string it simply returns it unchanged. Try this and you'll see changes:

declare @a as varchar(20)
select @a='DebasisDas'
select @a
select @a=REPLACE(@a,char(68),'b')
select @a

Thanks a lot azimmer