/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 vote155 views1 answer
Insert thai language sql server
SQL
4 votes185 views2 answers
Float postgres
SQL
0 vote179 views1 answer
Storing RGBA in mysql db
SQL
7 votes222 views4 answers
Mysql delete older duplicates
SQL
3 votes172 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
1 vote167 views1 answer
Reutrn string after character sql
SQL
14 votes185 views3 answers
Oracle sql limit results
SQL
0 vote167 views1 answer
What are the aggregate function in sql
SQL
0 vote176 views1 answer
Sql shell psql cannot enter password
SQL
0 vote180 views1 answer
Postgresql auto increment not working
SQL