/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 vote276 views1 answer
Running percentage of total postgres
SQL
0 vote316 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote285 views1 answer
Postgresql append array
SQL
0 vote253 views1 answer
Sql database size
SQL
0 vote285 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote263 views1 answer
Postgres drop type
SQL
1 vote266 views1 answer
Delete specific row in sql
SQL
0 vote291 views1 answer
Sql query wordpress export post
SQL
1 vote276 views1 answer
Window function mysql
SQL
0 vote284 views2 answers
How to take recent row without limit in mysql
SQL