serg-52 (12/26/2014)
TrySelect Phone1,Phone2 from tblregistration
where 'abc@yahoo.com,def@yahoo.com,efg@yahoo.com' like '%'+Usernames+'%'
That could end up being a pretty bad performance problem because it's not SARGable. Guaranteed table scan, if I'm reading that correctly.
--Jeff Moden
Change is inevitable... Change for the better is not.