Breaking News: Grepper is joining You.com. Read the official announcement!

sql create function

Shadow answered on November 26, 2021 Popularity 9/10 Helpfulness 5/10

answer sql create function

related create function syntax sql server

sql create function

Comment

ID       |       WebsiteName      |
-----------------------------------
1        |      www.yahoo.com     |
2        |      www.google.com    |
3        |      www.youtube.com   |

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

/* Running function */

SELECT ID, dbo.StripWWWandCom (WebsiteName)
FROM dbo.YourTable .....

ID      |      WebsiteName
--------------------------    
1       |        yahoo

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-function sql

Link to this answer
Share Copy Link

Contributed on Oct 13 2023

Shadow

0 Answers Avg Quality 2/10

Closely Related Answers

create function syntax sql server

Comment

CREATE FUNCTION Fact (@parameter datatype)
RETURNS returndatatype
AS
BEGIN
--sql statements
    RETURN --whatever you want to return but of returndatatype from above
END

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: create-function

Link to this answer
Share Copy Link

Contributed on Nov 26 2021

Kalineo

0 Answers Avg Quality 2/10

sql create function

Contents

More Related Answers

sql create function

Closely Related Answers

create function syntax sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.