Regular Expression for validating Website URL in SQL Server

Question

What is the regular expression for validating Website URL in SQL Server?

here's my query:

UPDATE INE
SET INE.ErrorDetails = INE.ErrorDetails +'WebSite not in correct format. (ex.www.testmail.com)'
FROM IntEmployees INE
Where 
    INE.WebSite Not like 'what is the expression for URL ??'
AND
    ISNULL(INE.InterfaceType_120,0) = 1
AND 
    INE.Status = 1

May be this can help stackoverflow.com/questions/23432166/… — Kiran Hegde
– Kiran Hegde, Commented Jul 9, 2014 at 7:10

Rupesh S · Accepted Answer · 2014-07-09 07:17:51Z

0

.... Where Website Not Like '%[^a-zA-Z0-9]%.[a-z][a-z]%'

answered Jul 9, 2014 at 7:17

Rupesh S

1251 silver badge15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Regular Expression for validating Website URL in SQL Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related