/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 vote202 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
-1 vote242 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote212 views1 answer
Mysql date only no time
SQL
0 vote206 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote218 views1 answer
Enable sql server full text indexing
SQL
1 vote194 views2 answers
Into sql
SQL
0 vote215 views2 answers
Update all columns in one update
SQL
0 vote200 views1 answer
How to remove default in mysql
SQL
0 vote220 views1 answer
Oracle current timestamp insert statement
SQL
0 vote220 views1 answer
Sql sum show 0 result
SQL