/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 vote287 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
3 votes311 views2 answers
Mysql update row
SQL
11 votes271 views2 answers
Having clause
SQL
2 votes292 views1 answer
Update with join sql server
SQL
0 vote331 views1 answer
Wordpress make wp user in db
SQL
1 vote295 views1 answer
Mysql check string don't have number
SQL
0 vote271 views1 answer
How to check if there is no database schema
SQL
5 votes307 views1 answer
Oracle add time to date
SQL
2 votes277 views2 answers
Mysql get time from datetime
SQL
24 votes331 views6 answers
Sql change table name
SQL