/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 vote205 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote196 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote247 views1 answer
Original Query
SQL
0 vote195 views1 answer
Find all tables where column name exists oracle
SQL
0 vote265 views1 answer
Month mysql
SQL
0 vote202 views1 answer
Show size of all tables postgres
SQL
0 vote230 views1 answer
Mysql backup query
SQL
0 vote212 views1 answer
Sql server phone constraint
SQL
14 votes245 views3 answers
Inner join sql oracle
SQL
31 votes233 views2 answers
Grant all priviledges to mysql user
SQL