/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 vote145 views1 answer
Postgres delete where id in
SQL
7 votes216 views1 answer
Show line number in sql server
SQL
9 votes196 views5 answers
Laravel to sql
SQL
4 votes182 views1 answer
Restart for pg_hba.conf file
SQL
0 vote163 views1 answer
Dump only schema
SQL
0 vote246 views1 answer
Month mysql
SQL
4 votes183 views2 answers
Select first and last row mysql
SQL
2 votes191 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote175 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote268 views1 answer
Trigger
SQL