Mixing Text and numbers
How do you mix numbers and text and sort properly? We designate lighting fixtures with codes that might be any of the following: 1, 2, 2A, 2A-1, TA, TA-19, TA-26, BG, BG1, BG2, etc.
I cannot figure out a way to sort them the way we want, since a field can only be either a number or text. Is there a way to convert text to a number (ie conver A to 1, B to 2, etc). If so, I could possibly split each code into several fields, and convert each letter to a number "behind the scenes", but I can't find any method of converting text to a number.
I would think this is a common requirement with serial numbers that mix text and numbers.