/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 vote276 views1 answer
Mysql best varchar length size
SQL
10 votes257 views3 answers
Sql select between two dates
SQL
1 vote256 views1 answer
Apex select list ORA-20999
SQL
3 votes271 views3 answers
Mysql declare variable
SQL
0 vote246 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote250 views1 answer
Mysql find db contarint
SQL
1 vote252 views1 answer
Select inside insert query
SQL
50 votes377 views6 answers
Sql count duplicate rows
SQL
0 vote251 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
2 votes242 views1 answer
Mysql list users on ubuntu
SQL