>jobno is nvarchar(20)
>I use sql analzyer to check .
Try:
select invno,jobno from apinvinfo where JOBNO = N'HKL0705035'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
