Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Update dbo.PersonDegree SET degree = case when (degree='M.D.', 'MD, CM', 'MD BS', 'MB, BCh', 'MB, BS', 'M.D./PhD.', 'MB, Ch.B.') 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.', 'Ph.D', 'PhD.')) 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' when degree='M. Phil.' then 'MS' when degree in('MS Ed', 'MS Ed.') then 'MSEd' ELSE degree 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.