Declare @EmailAddress as varchar(max) set @EmailAddress = ‘anthonyp@alpha.com’ IF ( CHARINDEX(‘ ‘,LTRIM(RTRIM(@EmailAddress))) = ” AND LEFT(LTRIM(@EmailAddress),1) ‘@’ AND RIGHT(RTRIM(@EmailAddress),1) ‘.’ AND CHARINDEX(‘.’,@EmailAddress ,CHARINDEX(‘@’,@EmailAddress)) – CHARINDEX(‘@’,@EmailAddress ) > 1 AND LEN(LTRIM(RTRIM(@EmailAddress ))) – LEN(REPLACE(LTRIM(RTRIM(@EmailAddress)),’@',”)) = 1 AND CHARINDEX(‘.’,REVERSE(LTRIM(RTRIM(@EmailAddress)))) >= 3 AND …

How to string format money in a sqlreader. Dim dNum1 As Double dNum1 = sqlDR(“Cost”) String.Format(“{0:c}”, dNum1)