/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 votes192 views1 answer
Tsql copy table
SQL
0 vote139 views1 answer
Sql ignore
SQL
14 votes132 views3 answers
Alter foreign key
SQL
0 vote135 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote125 views1 answer
Equi joins in oracle
SQL
1 vote130 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote134 views3 answers
Psql fatal database does not exist
SQL
1 vote137 views5 answers
Postgresql difference between two dates in days
SQL
1 vote130 views2 answers
Difference between in and between in sql
SQL
0 vote128 views1 answer
Mysql range of dates overlap
SQL