/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

0 vote101 views1 answer
Sql query to select records entered in last 24 hours
SQL
7 votes109 views1 answer
Set sequence value oracle
SQL
2 votes99 views1 answer
Oracle sql query to make column data uppercase
SQL
3 votes108 views1 answer
Ms sql skip take
SQL
0 vote63 views1 answer
Deleted table in sql trigger
SQL
0 vote112 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
8 votes100 views1 answer
Unique vs primary key
SQL
0 vote153 views1 answer
Mysql show schema
SQL
4 votes108 views4 answers
Pl sql output
SQL
0 vote109 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL