Need a Help

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

How about this?

DECLARE @Message Table ( ContenID INT , ContentMessages VARCHAR(2000))

INSERT INTO @Message (ContenID, ContentMessages)

SELECT 1, 'We have not received a payment for your loan account. this is debt collecor.'

INSERT INTO @Message (ContenID, ContentMessages)

SELECT 2, 'We have received a payment for your loan account.this is debt collecor.'

-- Code

SELECT REPLACE(ContentMessages,'this is debt collecor','') ContentMessages

FROM @Message

Gazareth One Orange Chip Points: 27737 More actions · Answer 2

Hi Unnati,

If I'm reading that right you want

We have not received a payment for your loan account. this is debt collecor.

We have received a payment for your loan account.this is debt collecor.

to become

We have not received a payment for your loan account.

We have received a payment for your loan account.

Correct?

If so, an UPDATE statement using REPLACE on the ContentMessage field should do the trick.

(Use a blank string as the third expression in the REPLACE clause)

Regards

Gaz

Ben Teraberry SSChampion Points: 11845 More actions · Answer 3

update dbo.messages

set ContentMessage = replace(ContentMessage, 'this is debt collecor.', '');

go

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

unnati.patel513 Say Hey Kid Points: 697 More actions · Answer 4

Say Hey Kid

Points: 697

February 9, 2012 at 10:33 am

Thank you very much Thats perfact.

i appreciated!!