i am new to baan
i am trying to write some sql querys
i have written following query

Uitem='COM'
select tibom010.*
from tibom010
where trim(tibom010.mitm) alike ':Uitem1%'

but its not working

Dear Rajesh,

No offence, but I think you are in a stage where you should first learn some basics on BaaN programming before experimenting, for you will otherwise struggle too much...

For this specific inquiry:
uitem(10;3) = "COM" |(first nine positions are for project, since item is a segmented field)
select tibom010.*
from tibom010
where tibom010._index1 = {:uitem}


Regards,
Eli Nager