Hi Oscar and welcome.
If the CC Number field is Character type
Should give you the first character for your look up table. LTRIM may not be required but often is.
If it is NUMERIC
should give you the first character in a new Character type calculated field from which you can do the lookup.
(Or of course you can simple use the appropriate formula when you define the lookup.)
Given the lookup will be quite constant over time an intrnal lookup table would seem like the best solution
An alternative is to use an IF function to calculate the field. For example;
Should give CC-AM if the number starts with3, CC-VM if itr starts with 4 or "Other" if it is neither 3 nor 4. (Assuming I typed the formula right!)
When I apply the formula it says "Invalid Delimeter" /b[/quote]Which formula?
Edit: The IF based formula needs another ) on the end.
I assume that was the one you had a problem with?