SQL User Define Function to Replace String

Create User Define Function that will Replace string from Column. So that Query or Stored Procedure remain neat.

 

 

Eg.

 

 

 

 

 

Create function dbo.ReplaceAddress (@input Varchar(250))

 

Returns Varchar(250)

 

 

As

 

Begin

 

Declare @Address Varchar(250)

Set @Address = @Input

Set @Address = Replace(Replace(Replace(Replace(@Address,' Drive' , ' .Dr'), ' Avenue', ' Ave.'), ' Road' ,' Rd.'), ' Street' , ' St.')

 

Return @Address

 

End

 

Here is Before and After Screenshot using UDF