Midrange News for the IBM i Community

Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
SQL WHERE clause question.....
has no ratings.
Published: 02 Jul 2013
Revised: 15 Jul 2013 - 1857 days ago
Last viewed on: 15 Aug 2018 (3546 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL WHERE clause question..... Published by: Chris Proctor on 02 Jul 2013 view comments(5)

Hello! A co-worker is trying to to select records where a field has a numeric value, but can contain some blanks. So, he needs to be able to select records where the field contains any 1-9 numeric values and possibly blanks.

Can this be done? If you have any suggestions I'm sure he'd appreciate hearing them.



Return to midrangenews.com home page.
Sort Ascend | Descend