/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

4 votes161 views1 answer
Postgresql change default value
SQL
4 votes141 views1 answer
W3schools create table
SQL
0 vote195 views1 answer
Get last inserted primary key
SQL
1 vote132 views1 answer
Grab all records from one table to another oracle sql
SQL
13 votes147 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
10 votes147 views2 answers
What is database
SQL
1 vote175 views1 answer
Show databases mysql docker
SQL
0 vote139 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote126 views1 answer
Order by ip address sql
SQL
23 votes137 views4 answers
How to uninstall postgresql in ubuntu
SQL