/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

2 votes131 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote117 views1 answer
Oracle sql drop table
SQL
1 vote117 views1 answer
Mysql dump specific tables
SQL
11 votes120 views2 answers
Having in sql
SQL
0 vote129 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote160 views1 answer
Postgres extract number from string
SQL
2 votes124 views1 answer
Oracle generated column
SQL
0 vote116 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
4 votes131 views2 answers
Sqlalchemy_database_uri for mysql
SQL
9 votes130 views3 answers
Mysql run sql file
SQL