/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 vote302 views1 answer
Postgresql regular expression special characters
SQL
0 vote343 views1 answer
What is delimiter in mysql
SQL
10 votes277 views1 answer
Oracle dependency
SQL
0 vote322 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote307 views1 answer
Check if database exists sql
SQL
0 vote316 views1 answer
Get date from timestamp in mysql
SQL
6 votes378 views2 answers
Install psql mac
SQL
0 vote344 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote309 views1 answer
Oracle shrink table
SQL
5 votes357 views1 answer
Mysql where one year ago
SQL