Creating listbox with SQL Like Statement

[Anonymous]

Experts,

Currently my scripts as follows

LOAD No,

     PID,

     SDATE,

     TCCODE,

     DESCRIPTION,

     QUANTITY,

     UOM,

     RATE,

     CURRENCY,

     PRICE,

     REPRESENTATIVE

     FROM

(ooxml, embedded labels, table is APR2016 )where DESCRIPTION like '*32*';

When I analyse the field values I have values  NODE 44232, DAILY BC 32, MONTHLY BC32, MONTHLY BC-32 etc

I need to query BC 32, BC32, BC-32 only. Like '*32*' is not suitable.

Also instead of putting the statement in Load, I would like to have a listbox (Expression)  with a Single SQL Like statement where user can select.

What is the expression I should use in Listbox?

Thanks

[Anonymous]

Hi Marco

To make clear understanding I have given 4 examples of my TCCODE. Some field may not have BC-32 or

Example 1: 'BC-32'

BC-32,  PH VALUES 7.2, MOISTURE < 10%, BROKEN < 0.5%,  PACKINGIN 10 KGS ONE SIDE LAMINATED BAGS. CARGO IN TRANSIT

Example 2: 'BC32'

PH VALUES 7.1, PACKAGING 10 KGS DOUBLE SIDE LAMINATED  BAGS, BC32 6 COLOR PRINTING, MOISTURE < 8%, BROKEN < 0.1%, 

Example 3: 'BC 32'

PH VALUES 7.0, VAPOUR %0.2, PACKAGING 5 KGS DOUBLE SIDE LAMINATED  BAGS, BC 32 6 COLOR PRINTING, MOISTURE < 8%, PENDING CLEARANCE

Example 4: No 'BC 32/BC32/BC 32'

PH VALUES 7.0, VAPOUR %0.2, PACKAGING 25 KGS DOUBLE SIDE LAMINATED  BAGS, 2 COLOR SINGLE SIDED PRINTING, MOISTURE < 1%, CLEARED IN TRANSIT

So I need to Select all columns which has BC 32 or BC-32 or BC32

Now temporarily I am using it in Load.

(ooxml, embedded labels, table is APR2016  where TCCODE like '*BC 32*' or TCCODE like '*BC32*' or TCCODE like '*BC-32*' ;

This I would like to change it to a Listbox like below. upon clicking the list box, the expression similar to where clause should be executed.

Hope I am not creating any confusion. Thanks

[swuehl · Accepted solution]

Maybe

LOAD No,

     PID,

     SDATE,

     TCCODE,

     If(Wildmatch(TCCODE,'*BC32*','*BC 32*','BC-32*'),'Find     *BC32* or *BC 32* or *BC-*32') as FindTCCode,

     DESCRIPTION,

     QUANTITY,

     UOM,

     RATE,

     CURRENCY,

     PRICE,

     REPRESENTATIVE

     FROM

(ooxml, embedded labels, table is APR2016 );

Then use FindTCCode in a list box and make the selection to filter.

[Anonymous]

Thanks Stefan.