/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 vote280 views1 answer
Delete ids between sql
SQL
0 vote219 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote202 views2 answers
Get all index postgres
SQL
1 vote226 views2 answers
Mysql add column tinyint default 0
SQL
0 vote216 views1 answer
How do you insert boolean to postgresql
SQL
2 votes201 views1 answer
Import large .sql files into lampp
SQL
0 vote188 views1 answer
Metada in sql
SQL
1 vote212 views1 answer
SQL: merging multiple row data in string
SQL
5 votes216 views3 answers
MySql get fields of table
SQL
0 vote219 views1 answer
SQL division of an integer by another integer get float CAST
SQL