>(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 ???
What is type of the field JOBNO?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.