Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Update dbo.PersonDegree SET degree = case when (degree='M.D.') then 'MD' when (degree in('B.Sc.', 'B.S.', 'B.S', 'BS(High Honors)', 'BS/MS', 'B.sc.', 'BSc')) then 'BS' when (degree IN('Ph. D.', 'Ph D', 'Ph.D.')) then 'PhD.' when (degree IN('M.S.', 'Masters', 'M. Sci.')) then 'MS' when degree='DMD' then 'DDM' when degree ='Psy.D' then 'DPSY' when degree in('B.A', 'B.A.') then 'BA' when degree='B.M.S.' then 'BMS' when degree='D.O.' then 'DO' when degree='DNSC' then 'DSN' when degree='M.A.' then 'MA' when degree='M.B.B.S' then 'MD' when degree='MS.B' then 'MSB' when degree='P.A.' then 'PA' when degree='MSN BS' then 'MSN' End
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.