/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

5 votes172 views2 answers
Ranking functions in sql
SQL
0 vote217 views1 answer
Pagination with row_number
SQL
0 vote172 views1 answer
Table values functions in SQL
SQL
0 vote172 views10 answers
John the ripper mysql
SQL
0 vote183 views2 answers
Mysql set foreign_key_checks=0
SQL
5 votes205 views1 answer
Oracle get ddl
SQL
0 vote182 views1 answer
Psql datestyle
SQL
3 votes212 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote186 views1 answer
How to check which table has data in mysql
SQL
0 vote172 views1 answer
MySql get primary keys of table
SQL