IF Statement

[Anonymous]

Hi All

How can i do the following in the script?

if TransType = '11','12','13' TransType

so i only want data from the table if TransType is 11, 12 13

Thanks

[sunny_talwar · Accepted solution]

May be use Where Statement:

LOAD FieldName

FROM Table

Where Match(TransType, 11, 12, 13);

[alexandros17]

In the where condition :

Where ... Wildmatch([TransType], '11','12','13') > 0

[Anonymous]

....Again Thanks!!!

[puttemans]

IF(TransType > 10 and TransType < 14, DO SOMETHING)

[sunny_talwar]

No problem