/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 vote206 views1 answer
Wherein mysql
SQL
27 votes206 views6 answers
Sql update record
SQL
0 vote188 views1 answer
Postgresql create table with boolean column
SQL
-1 vote180 views1 answer
How to format tables in sqlplus
SQL
0 vote155 views1 answer
Print sum of values sql
SQL
0 vote200 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote204 views1 answer
How to add timestamp column in mysql
SQL
6 votes184 views1 answer
What is where clause in sql
SQL
1 vote193 views1 answer
Sql order by timestamp
SQL
0 vote182 views1 answer
How to user id to show in from date to upto date in mssql server
SQL