i had the fiield as “ino 6375” there is double space between ino and 6375
when i am giving condition not equal to ino 6375 at query panel level , but sql is parsing it as ino 6375 , so iam unable to filter on this
kindly help me on this
bo.manojkumar 
(BOB member since 2010-01-11)
In database the value has 2 spaces right, how sql is parsing? with single space? question is confusing, can you explain clearly.
There are number of string functions, try to use these functions in formula
space(),
instr(),
substr()
See help for these functions if you have any doubts. hope it helps.
anil.ganga1 
(BOB member since 2007-07-04)