/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

15 votes244 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote114 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote101 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote105 views1 answer
How to select only id where is not in column mysql
SQL
4 votes113 views1 answer
Id increment ms sql server
SQL
0 vote107 views1 answer
Update top 100 order by sql server
SQL
0 vote113 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote100 views3 answers
Sql all columns
SQL
13 votes62 views2 answers
Oracle all source
SQL
1 vote64 views1 answer
Mysql show attributes of a table
SQL