Hi Hani
If the select statement you have written is correct, you are actually asking for ALL records! PLease drink a cup of coffee, and reread it.
*I am using SQL Statement which brings more records than I need because it behaves like SET EXACT OFF, here is my statement
*SELECT code from items where alltrim(code) >= '140' and alltrim(code) <= '140'
*The Result sets contains records for item = '140' and item = '1404'
*I even tried to set exact on but with no change.
*Any Help on that