/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

1 vote146 views2 answers
Datetrunc hour snowflake
SQL
0 vote138 views1 answer
Datetime postgres typeorm
SQL
0 vote146 views4 answers
Change schema in sql server
SQL
2 votes146 views1 answer
Q operator in sql
SQL
11 votes148 views2 answers
How to import mysql database command line
SQL
15 votes144 views6 answers
Psql
SQL
0 vote181 views1 answer
Postgres select from values
SQL
2 votes135 views1 answer
Sql find missing values between two tables
SQL
2 votes137 views1 answer
Pandas to sql index
SQL
0 vote137 views2 answers
How to combine two sql queries in one result
SQL