I'm using
substring([tblSearsItem].[Style],3,1)
to strip out the third character as a field. The result will be 'B', 'M', 'J', or 'T'
When the result is B, I want to display "Boys" in the SP as the column 'Gender'
When the result is M, I want to display "Mens" in the SP as the column...