Re: SQL and Data Selection/Filtering

Select recust#, reparent, cmcust, cmname From datalib.refile inner join
datalib.cmfile on recust# = cmcust Where cmname like 'A%' Order by
cmname

should be as simple as adding an or clause.



hostvar = 'A%'
Exec SQL
 Select recust#, reparent, cmcust, cmname
 From datalib.refile
 inner join datalib.cmfile on recust# = cmcust
 Where (cmname like :hostvar or :hostvar = ' ')
 Order by cmname
End-Exec


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
We've built a better hotcake -- Stacked and Stuffed Hotcakes -- coming
January 11th!
For hotcake tips, interviews with our chefs and more, check out the Stacked
and Stuffed blog at http://imstuffed.blogspot.com