I have item called ABCD in itemdata but when am wring select query
where tiitm001.item = "ABCD" its not going to selectdo
Its triggering selectempty. when we are storing items how it will be stored exactly and when it checks eqaulity how it checks.

rgds,
jack

If your item domain (tcitem) is right aligned, you would not find the item in this way. Use the following:


domain tcitem t.item fixed

tt.align.according.domain("ABCD", t.item, "tcitem")
...
where tiitm001.item = :t.item