/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

36 votes307 views6 answers
Change column data type sql
SQL
0 vote215 views1 answer
Connecting mySQL to STS
SQL
0 vote200 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote184 views2 answers
Postgres default user
SQL
0 vote196 views1 answer
Mysql database hyphen
SQL
29 votes228 views6 answers
Delete all rows from table mysql
SQL
0 vote250 views1 answer
How to rename a database in tsql
SQL
1 vote199 views1 answer
Tsql get beginning of year
SQL
2 votes182 views1 answer
Scaffold npgsql net core
SQL
0 vote219 views1 answer
Testing sql queries
SQL