Ask - Replace a Word in SQL Server 2008

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

Replace a Word in SQL Server 2008

Jun 1 2011 12:00AM by Karthikeyan G

I want a function which would replace a text 'Cost of 12 centimeter scale is $15, is of 40cents.' to 'Cost of 12 centimeter scale is £15, is of 40pence.'

In this i want to replace Cent - Pence and $ - £ can u plz give solution for this,

Submitted under: Microsoft SQL Server · · · ·

Previous: SSRS Subscription - How to increment a file with a date instead of a number
Next: SQL procedure optimization

Karthikeyan G

1554 · 0% · 12

1 Replies

Karthi, you can create a function like below...and u can use that as i showed i below.

create function fnreplaceText
(
    @str varchar(max)
) returns varchar(max)
as
begin
    return replace(replace(@str,'Cent','Pence'),'$','£')
end

GO

select dbo.fnreplaceText( 'Cost of 12 centimeter scale is $15, is of 40cents.')

commented on Jun 1 2011 12:01PM

Ramireddy

2 · 41% · 12972

Your Reply

Sign Up or Login to post a comment.