/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 vote274 views1 answer
Postgresql using reserved word as column name
SQL
1 vote292 views1 answer
Mysql print variable
SQL
0 vote304 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote282 views1 answer
View psql output in horizontal scrolling
SQL
0 vote265 views1 answer
Codeigniter dbforge add index
SQL
2 votes262 views1 answer
Sql ignore accents
SQL
9 votes291 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote246 views1 answer
Create dabase postgresql
SQL
0 vote284 views1 answer
Select lowest values sql
SQL
8 votes291 views1 answer
See all users mysql
SQL