/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

2 votes271 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote184 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
1 vote187 views1 answer
Oracle grant on all tables in schema
SQL
0 vote176 views1 answer
Myswql show full processlist
SQL
0 vote201 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
1 vote152 views1 answer
Unique vs distinct sql
SQL
2 votes185 views6 answers
In in sql
SQL
3 votes197 views1 answer
Oracle apex message quit website
SQL
1 vote178 views1 answer
How refresh navicat tables to see new tables
SQL
31 votes201 views3 answers
Sql count
SQL