May 17, 2018

Handy Function to Test for Email Validity

Use this nifty function to check the validity of an email address. CREATE FUNCTION [dbo].[fnCheckEmail](@Email VARCHAR(255)) RETURNS BIT AS BEGIN DECLARE @ValidEMail BIT IF @Email IS NOT NULL SET @Email = LOWER(@Email) SET @ValidEMail = 0 IF @Email LIKE ‘[a-z,0-9,_,-]%@[a-z,0-9,_,-]%.[a-z][a-z]%’ AND @Email NOT like ‘%@%@%’ AND CHARINDEX(‘[email protected]’, @Email) = 0

Seamless Upgrade to Angular 5

In this article we’re going to explore Angular 5 up-gradation and Changes that would be encountered during the migration. Take a look at the features that make Angular 5 a great option for your development projects.