/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 vote390 views2 answers
Amazon linux postgresql client
SQL
0 vote366 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote372 views1 answer
Xampp increame mysql speed
SQL
4 votes358 views1 answer
Mysql not equal
SQL
1 vote368 views4 answers
Sql now
SQL
0 vote377 views1 answer
Command line mysql xampp
SQL
11 votes358 views2 answers
Turn off safe mode mysql
SQL
-1 vote352 views2 answers
On update cascade
SQL
1 vote300 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote362 views2 answers
Mysql row_number() example
SQL