(1) select invno,jobno from apinvinfo where ltrim(rtrim(JOBNO)) ='HKL0705035'
(2) select invno,jobno from apinvinfo where invno ='MAEU854396577'

For statement(2) It return the correct result
MAEU854396577 HKL0705035

However for statement(1) , it return nothing !!!
I make sure that Job no "HKL0705035" exist in the table (apinvinfo)
why statement(1) fails ???