[RBASE-L] - SQL help

[Dan Champion]

Hi,

  I am trying to exclude some rows with a select clause, but I am not thinking straight evidently. The command:

select jobnum from joblist whe finalbill is not null

Produces a set of records, Yet I wish to only include those that have a 5 as the 5th digit in Jobnum (text)

Jobnums =
20055123
20051123
20053123
20055124

I would like only

20055123
20055124

to come up.  I assume I need a sub select.


The whole print command I am using now is:

Print Prodrept whe Jobnum in +
  ( select jobnum from joblist whe finalbill is not null ) +
 and wdate between . s1date and . s2date

Any Ideas?

Thanks in advance.
Dan

Dan Champion
www.championsolutions.net
616-299-7420