replace

Question

Post reply

replace

elham_azizi_62

SSCertifiable

Points: 5095
More actions
August 28, 2012 at 4:17 am

#260562

hello all.
I have one string like this:'0,0,'',0,'',0' and i want to my result this:'0,null,'',0,'',0' please guide me how to do i do for this result?
thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 1

Do you always want to NULL the second zero, or is it more complicated?

elham_azizi_62 SSCertifiable Points: 5095 More actions · Answer 2

elham_azizi_62

SSCertifiable

Points: 5095

August 28, 2012 at 4:33 am

#1530683

yes always

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

elham_azizi_62 (8/28/2012)
hello all.
I have one string like this:'0,0,'',0,'',0' and i want to my result this:'0,null,'',0,'',0' please guide me how to do i do for this result?
thanks

No problem.

-- set up sample data

DECLARE @String VARCHAR(50), @Replacement VARCHAR(50)

SELECT @String = '0,0,'',0,'',0', @Replacement = '0,null,'',0,'',0'

SELECT String = @String, Replacement = @Replacement

-- solution

SELECT CASE WHEN @String = @String THEN @Replacement ELSE @String END

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 4

You can do this:

SELECT REPLACE('0,0,'',0,'',0', '0,0', '0,NULL')

This will be OK as long as the pattern only occurs once in the string.

elham_azizi_62 SSCertifiable Points: 5095 More actions · Answer 5

elham_azizi_62

SSCertifiable

Points: 5095

August 28, 2012 at 4:51 am

#1530695

thanksssssssssssssssss

elham_azizi_62 SSCertifiable Points: 5095 More actions · Answer 6

but there is one problem

my string is parameter that fiil from one function and function returns '0,0,'',0,'',0'

now how do i do?

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 7

elham_azizi_62 (8/28/2012)
...
my string is parameter that fiil from one function and function returns '0,0,'',0,'',0'
now how do i do?

I can only guess what you are trying to say here, it makes no sense in English! Please can you try again?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden