Essentially, I have a table that has a column with either an 8 digit number or a 4 digit number. My goal is to created a new column that simply has an "8" or a "4" indicating the number of digits that are found in the other column. Is it possible to do this with a case statement?