How to write a case... from ... to... 1

[choochoowinn2009]

Hi,

How would I write a formula to change my service codes to the group code "Basic"?

These are my service codes:
1) A123
2) S5286
3) H1111
4) H1112
5) H1113
6) H1114
7) H1115
8) H1116
9) H1117
10) H1118

I know how to write a case to change each service code to "Basic", but how would you write the formula to show from H1111 to H1118 without having to type each service code individually?

Thank you for your help!

C

 

[lbass]

select {table.code}
case 'A123', 'S5286','H1111' to 'H1118' : 'Basic'
default : 'Other' //or {table.code}

-LB

 

[choochoowinn2009]

Thank you! It works!