IsUrlValid

Checks the validity of a URL string

Syntax:

SELECT SQLHTTP.net.IsUrlValid( @Url )

Arguments:

Name	Type	Description
@Url	nvarchar(4000)	Web address

Return Type:

bit

Return Values:

0 = Url is NOT Valid
1 = Url IS Valid

Remarks:

This function only validates the structure of the URL but does not validate the existence of the web address

Sample Usage:


DECLARE @Url varchar(MAX)

SET @Url = 'https://www.google.com'
	
SELECT SQLHTTP.net.IsUrlValid(@Url)

DECLARE @Url varchar(MAX)

SET @Url = 'https://www.google.com'

SELECT SQLHTTP.net.IsUrlValid(@Url)

-----