/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 vote170 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
10 votes179 views2 answers
Mysql remove only_full_group_by permanently
SQL
8 votes182 views1 answer
Oracle search text in all packages
SQL
10 votes158 views2 answers
Linux command line import mysql database
SQL
0 vote207 views1 answer
Grouping by email domain mysql
SQL
-1 vote161 views1 answer
Ssms connect with connection string
SQL
0 vote154 views1 answer
Create date sql
SQL
0 vote201 views1 answer
Install postgresql 12 on debian 10
SQL
9 votes171 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote160 views1 answer
Set column width in sqlplus
SQL