/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 vote258 views1 answer
Rows, INSERT INTO, Returning
SQL
6 votes224 views3 answers
Mysql server is not starting xampp
SQL
0 vote241 views1 answer
Mariadb select limit offset
SQL
1 vote235 views1 answer
Create procedure with encryption
SQL
0 vote227 views1 answer
Mysql concat and use as where column
SQL
-1 vote235 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
8 votes244 views1 answer
Oracle create datafile
SQL
1 vote245 views4 answers
Alter schema sql
SQL
0 vote229 views1 answer
How to define a save method in ruby for sql databases
SQL
4 votes233 views1 answer
Restart for pg_hba.conf file
SQL