/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 vote289 views1 answer
Oracle convert int to date
SQL
2 votes234 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote231 views1 answer
Postgres check for foreign key
SQL
0 vote238 views1 answer
Postgresql linux password
SQL
3 votes225 views1 answer
Convert sqlite table to pandas dataframe
SQL
15 votes228 views6 answers
Psql
SQL
7 votes247 views2 answers
MySQL IF without else
SQL
0 vote235 views1 answer
Sql select upcoming birthdays
SQL
0 vote227 views2 answers
Sql query in dax power bi
SQL
0 vote228 views1 answer
Sqlalchemy sequence postgresql
SQL