How to find Items that begins with a specified string

[mirx74]

Hi,
I need to create a BSFN to perform a select in F4101 by LITM alias to search items that begins with a certains string (in input).

What can I do and how ?

thanks in advance for any tip
Mirko

 

[BOster]

You can do this with the C API JDB_SetSelectionX. It will allow you to do a wild card WHERE clause among many other things.

 

[tpw_nz]

You could use a table IO Fetch Single or Select and use the Like operation (~ above - symbol). Prefix your string with % and the generated SQL will use perform a Like search.

 

[mirx74]

Thanx to all.. I used the TableIO solution.

The number of records expected is from 0 to 5 on the F4101 for a where statement using like clause on LITM alias..

Thanks again

 

[mirx74]

TableIO solution has been used.

Thanks to all