/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

1 vote145 views1 answer
Postgres delete from where date is greater than specific date
SQL
2 votes177 views1 answer
Tcl in sql
SQL
0 vote146 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote241 views1 answer
Mysql data from file
SQL
1 vote132 views1 answer
Set mysql mode global query
SQL
1 vote141 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
50 votes235 views6 answers
Sql count duplicate rows
SQL
0 vote93 views0 answer
SQL
3 votes167 views1 answer
Export postgres database linux
SQL
1 vote127 views1 answer
Use of now() in mysql
SQL