/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 vote155 views1 answer
Sql ignore
SQL
-1 vote173 views4 answers
Postgres between dates
SQL
0 vote142 views1 answer
Mysql remove tabs from string
SQL
0 vote186 views1 answer
Prisma transaction
SQL
-3 votes136 views1 answer
Remove spaces sql 2008
SQL
0 vote157 views1 answer
Tinydb add table
SQL
4 votes159 views2 answers
Float postgres
SQL
0 vote161 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote136 views1 answer
Mysql update sequence with order by
SQL
22 votes256 views4 answers
Tsql rename table
SQL