/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

1 vote334 views1 answer
Python escape string for sql
SQL
0 vote358 views1 answer
DATEDIFF minute postgres
SQL
9 votes371 views3 answers
Pyodbc connect to sql server
SQL
0 vote345 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote311 views1 answer
SQL server select to get sum of hours
SQL
0 vote352 views1 answer
Mariadb errno 121
SQL
0 vote337 views1 answer
Connect postgresql using a connection string
SQL
0 vote372 views1 answer
Allow null in psql
SQL
10 votes344 views1 answer
Query to find object dependencies in oracle
SQL
2 votes336 views1 answer
Create table with primary key
SQL