Paul, Do the data types of yield and tensile match? Try WHERE yield < (tensile) so that R:BASE will cast the datatype of tensile if necessary.
Bill On Fri, Jan 31, 2014 at 4:29 PM, Paul Buckley <[email protected]>wrote: > Good Afternoon list, > > This should be easy but my brain is stuck in a Friday rut. I'm trying to > browse all the rows from table test where the value of column1 is less than > column2. I tried this and it failed: > > Bro all from mechanicals where yield < tensile > > I've tried a couple of other variants with no luck. Any suggestions? > > Thanks in advance, > Paul Buckley > > >

