IsValidUrl.sql

CREATE FUNCTION [dbo].[IsValidURL] (@Url VARCHAR(200))
RETURNS INT
AS
BEGIN
    IF CHARINDEX('https://', @url) <> 1 AND CHARINDEX('http://', @url) <> 1
    BEGIN
        RETURN 0;   -- Not a valid 
    END

    -- Get rid of the http:// stuff
    SET @Url = REPLACE(@URL, 'https://', '');

	-- Get rid of slashes
    SET @Url = REPLACE(@URL, '/', '');

    -- Now we need to check that we only have digits or numbers
    IF (@Url LIKE '%[^a-z0-9]%.%[^a-z0-9]%.%[^a-z0-9]%')
    BEGIN
        RETURN 0;
    END

    -- It is a valid URL
    RETURN 1;
END