/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 vote379 views1 answer
Sqlalchemy empty table
SQL
4 votes376 views2 answers
Truncate oracle
SQL
7 votes364 views4 answers
Lowest salary in sql
SQL
0 vote382 views1 answer
Neo4j command to run script file
SQL
2 votes376 views1 answer
Merge firstname and lastname in sql oracle
SQL
1 vote378 views1 answer
Mysql search like order by best match
SQL
0 vote365 views1 answer
Restore backup mysql .gz
SQL
6 votes361 views2 answers
Stored procedure to delete data from table in mysql
SQL
1 vote337 views1 answer
Sql server reseed single table
SQL
0 vote368 views1 answer
Mysql search like but first exact match
SQL