|
Hi everyone. I have an SQL selection problem A file contains numerous fields, including Field A Alpha 6 FieldB Packed 4 0 I want to select any records that have FieldA = spaces OR FieldA contains numerics only and the number in FieldA = the number in FieldB I tried the following select * from File where (FieldA = ' ' or (FieldA <> ' ' and FieldB = DEC(FieldA))) Interactively, I get the following error Selection error involving field XFLG11. Anyone any thoughts on how to code SQL for this situation? Thanks in advance Alan Shore NBTY, Inc (631) 244-2000 ext. 5019 AShore@xxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.