Filter values from INLINE starting with certain numbers

[microwin88x]

Hello,

I have my Script with an INLINE table for field ID with values:

000

005

020

035

Then I have my Fact Table with the ID and other fields.

The thing is that I need to get the IDs STARTING with the values from INLINE.

For example, IDs: 000835, 005358, etcetera.

Is there any way to do this in the WHERE clause from the Fact Table?

(If I make a Where Exists(ID) in the Fact Table, I'd only get values 000, 005, 020 and 035)

Thank you!

[MK_QSL]

Temp:

Load Num#(ID,'000') as ID INLINE

[

  ID

  000

  005

  020

  035

];

Sales:

Load

  CustomerID,

  Sales

  Where Exists (ID, ID1);

Load

  Num#(CustomerID,'000000') as CustomerID,

  Num#(Left(Num#(CustomerID,'000000'),3),'000') as ID1,

  Sales

Inline

[

  CustomerID, Sales

  000835, 100

  000122, 120

  005140, 200

  001256, 100

];