Solved

AS400 Query selection question

Posted on 2010-08-26
2
621 Views
Last Modified: 2013-12-06
I'm not able to get my selection correct and this is something that is need asap.... I would normally use sql, but need it in query.  

please see attached
query-selection.doc
0
Comment
Question by:lynn_harris
2 Comments
 
LVL 5

Accepted Solution

by:
stevebowdoin earned 500 total points
ID: 33534448
use "range" and "list"..

as soon as you put that "or" in there you start over...

Steve

ds.bmp
0
 

Author Closing Comment

by:lynn_harris
ID: 33534695
excellent.  List is great.  Thanks!!!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now