Looking for a Specific Number/Begins With

[Kimmie]

Hi All,

I am trying to create a basic calculation to return a Word IF a number in a field begins with a specific number. This is for auto text for credit cards. So if the number begins with 3 then its an America Express. How would I write that?

Thanks for your help!

[Genx]

Case( Left( NumberField ; 1 ) = "3"; "American Express" ;

Left( NumberField ; 1 ) = "5" ; "Major Credit Card" ;

Left( NumberField ; 1 ) = "4" ; ""Major Credit Card" ;

Left( NumberField ; 1 ) = "n" ; "Something Else"

)