How to apply different filters for different customers

[Vaku1606]

Hello, 

I have following data: customer code, customer name, sales order quantity, sales order date, sales order type.

How can I apply different filters for different customers?

For example: For customer code 123 we need just sales order types x,y,z

                            For all other customers (except customer 123) we need sales order types a,b,c, x,y,z

How can I write this in script?

Thanks in advance

[vinieme12]

Load * From SomeSource

Where  (customer='123' and wildmatch(ordertype,'x','y','z')) 

 OR

( customer<>'123' and wildmatch(ordertype,'a','b','c','x','y','z')