LOAD RESIDENT | WHERE = MULTIPLE VALUES

[nico_ilog]

Hey Guys,

I need some help!

Maybe i'm just being a NOOB! But i need to know if there is a possibility to do a Resident load, specifying MULTIPLE parameter field values for the one specified field?

Resident SalesDetails

WHERE left(SH_CashSlipId,1) = 'C' OR 'D';

Drop Table SalesDetails;

How does this work?

Because this:

Resident SalesDetails

WHERE left(SH_CashSlipId,1) = 'C';

Drop Table SalesDetails;

Works fine?

Thanks in advance?

[alexandros17 · Accepted solution]

the sysntax is:

WHERE left(SH_CashSlipId,1) = 'C' OR left(SH_CashSlipId,1) = 'D';

or you can use

Where Wildmatch( left(SH_CashSlipId,1) ,'C','D')>0

[maternmi]

Hi,

try this

WHERE

left(SH_CashSlipId,1) = 'C' OR left(SH_CashSlipId,1) 'D';

Drop Table SalesDetails;

BR

Michael

[nico_ilog]

Thanks brother! Worked!