/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 vote297 views1 answer
Postgresql certain first 4 characters in string
SQL
11 votes278 views2 answers
Sql rank
SQL
0 vote281 views1 answer
Google sheets filter rows above current cell
SQL
3 votes299 views1 answer
Oracle failed login attempts
SQL
5 votes279 views2 answers
Ranking functions in sql
SQL
0 vote291 views1 answer
Insert into select with group by
SQL
0 vote296 views1 answer
Mysql sql select one day before
SQL
0 vote294 views1 answer
Postgresql comandos basicos
SQL
0 vote281 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote283 views1 answer
Rabbitmq service not starting
SQL