Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Wierd Results |
Thu, Feb 28 2008 2:34 PM | Permanent Link |
Allan Brocklehurst | 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 Attachments: Lookup.doc |
Fri, Feb 29 2008 8:26 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |