Hello;
I ran the following 2 statements in dbsys (seperately) and get eh same results

select [ITEMNO],[Description],[PRIMARY VENDOR NUMBER],[PRIMARY VENDOR NAME],[VENDOR CATALOG NUMBER]
from dha10itemmaster
where [ITEMNO] not in (select [Facility Item Number] from DHA10_POHist_200601);


select CAST([ITEMNO]AS CHAR(10)),[Description],[PRIMARY VENDOR NUMBER],[PRIMARY VENDOR NAME],[VENDOR CATALOG NUMBER]
from dha10itemmaster
where [ITEMNO] not in (select [Facility Item Number] from DHA10_POHist_200601);

The results, see attached word doc , have the leading zeros fro the ITEMNO strips out .
ITEMNO AND  "Facility Item Number" are string fields

Am i missing something here?


TIA

Allan

What is happening here

Allan,

<< The results, see attached word doc , have the leading zeros fro the
ITEMNO strips out . ITEMNO AND  "Facility Item Number" are string fields >>

I assume this is with the second query, and not the first ?  I tried a
similar query here and the leading zero's stay put.  I used a string field
for the source field type, and the values "0000010", "0000020", and
"0000030".

--
Tim Young
Elevate Software
www.elevatesoft.com