/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 vote113 views1 answer
Metada in sql
SQL
1 vote110 views1 answer
Sql server 2016 reseed identity
SQL
0 vote134 views1 answer
SQL server datetime compare
SQL
0 vote124 views1 answer
Stored function in sql
SQL
0 vote133 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote119 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote117 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote135 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote125 views1 answer
Mysql query single row
SQL
0 vote136 views1 answer
Sql server roles and users
SQL