I need find in F0101 using the field TAX, but I will find only sending 8 caracteres (the field TAX-size 20). What I can do ?

I need find in F0101 using the field TAX, but I will find only sending 8 caracteres (the field TAX-size 20). What I can do ?

The command Select do Enterprise One don´t have the instruction "LIKE" of SQL.
Example: TAX = 01234101000100
Find using TAX = "01234101" (only 8 caracteres)

Re: I need find in F0101 using the field TAX, but I will find only sending 8 caracteres (the field TAX-size 20). What I can do ?

Jefferson,

Set up a variable to hold your selection criteria and append a percent sign (in your example the variable would contain '01234101%'). On the Mapping page of Table I/O map the variable to the 'TAX' column and set the Operation to LIKE which looks like an underscore (_) with a tilde (~) over it.

Barry

Re: I need find in F0101 using the field TAX, but I will find only sending 8 caracteres (the field TAX-size 20). What I can do ?

Barrier,

Thanks for your information.

Jefferson