I'm working in SQL 2012. I have a year field represented as a 2 or 3 digit number. If the century is 1900 it's a 2 digit number (e.g., 89=2009). If the century is 2000 it's a three digit number starting with 1 (e.g., 100=2000) .
I'm trying to figure out a way to create a 4 digit year value given the 2 or 3 digit year code.
I'm not even sure where to start. I was thinking a case statement but the years range about 50 years in time so it'd get a bit tedious.
Thanks in adavance!