/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

3 votes335 views4 answers
Stop MySQL
SQL
0 vote336 views1 answer
Sql tabelle erstellen
SQL
22 votes365 views3 answers
How to join three tables in sql using joins
SQL
9 votes361 views4 answers
Mysql set id auto increment
SQL
0 vote322 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote317 views1 answer
Json_remove mysql
SQL
1 vote344 views1 answer
Create new index takes long time postgresql
SQL
2 votes340 views2 answers
Sql percentage
SQL
4 votes294 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote355 views2 answers
Sql day from datetime
SQL