/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 vote142 views1 answer
Sql alchemy with azuresql server
SQL
0 vote119 views1 answer
Import csv to mysql
SQL
0 vote116 views1 answer
Expose db in virtualbox
SQL
3 votes124 views1 answer
Postgresql where current year
SQL
0 vote159 views1 answer
Mysql set variable to today's date
SQL
2 votes158 views4 answers
Mysql get all tables row count
SQL
0 vote158 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote239 views1 answer
Postgres list all stored procedures query
SQL
0 vote155 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
1 vote164 views1 answer
ORACLE RIGHT TWO DIGITS
SQL