Hello All,

If possible I need some urgent Reply/Confirmation?

Is it possible to have wild card character search on LNFP7 table field.

Say user will give input as "Test" and I have query table ttmmm999 and take all records for which i get matching records, say i have to match with field ttmmm999.fnam.

so out should be all records like

test1
AllTest1233
123Test
Testeeee...
...
...

its like searching for *test*....

So "Test" can appear any where in the field ttmmm999.fnam and also search should be case in-sensitive, added to that ttmmm999.fnam is multibyte :(
there no UPPER or LOWER case restriction on table field, in table it can be stored as lower case or upper case.

Thank you,

I am Looking for urgent Help.

You need to convert the string programmatically like ".*[Tt][Ee][Ss][Tt].*" and then use dynamic sql on the table with like clause . It should and will work . It works in Baan IV.

Thank You Hitesh for quick reply.
I did what you suggested, It worked, added few checks for mb-char
my work is not finished yet, will update more, later on, once done.