/SQL/Create function in microsoft sql server

Create function in microsoft sql server

CREATE FUNCTION dbo.StripWWWandCom (@input VARCHAR(250))
RETURNS VARCHAR(250)
AS BEGIN
    DECLARE @Work VARCHAR(250)

    SET @Work = @Input

    SET @Work = REPLACE(@Work, 'www.', '')
    SET @Work = REPLACE(@Work, '.com', '')

    RETURN @work
END

Source: stackoverflow.com

Similar codes

7 votes325 views3 answers
Sql get last inserted row
SQL
0 vote326 views2 answers
Mysql password error create datbase
SQL
0 vote337 views1 answer
Dump db only triggers mysql
SQL
0 vote353 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote358 views1 answer
How to remove quotes from a string in ssis load file
SQL
4 votes340 views1 answer
Sql quote in string
SQL
5 votes341 views1 answer
Oracle generate list of dates in between a date range
SQL
11 votes347 views2 answers
Mysql set safe mode off
SQL
0 vote356 views1 answer
Sql last 3 rows
SQL
0 vote363 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL