calculation combining Left and Case statements
Left (text; numberof characters) and a
I have a number in a field 6132 and I want to get the left value = 6
easy enough I use the LEFT function. But I want if the value is 6 the field to calculate "S"
Final answer results as "S" for 6132