/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 vote193 views1 answer
Count column of tables psql
SQL
3 votes161 views2 answers
Tsql join multiple record in one string
SQL
1 vote176 views1 answer
Convert to hexadecimal sql
SQL
0 vote127 views1 answer
Jooq finding lastest value in table
SQL
0 vote140 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote157 views2 answers
Sql searching via key word
SQL
1 vote191 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote142 views1 answer
Excute raw query
SQL
1 vote150 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote142 views1 answer
Join creating duplicate columns sqllite
SQL