I suppose that you could say WHERE DATABASE.TABLE.COLUMN >= "QT" AND
DATABASE.TABLE.COLUMN <= "QT";  :-)


On Wed, 9 Oct 1996, Greg Rice wrote:

> I have a select statement that is generating the following error in
> imagesql.
>
> IMAGE/SQL error 111; TurboIMAGE error -52; TurboIMAGE intrinsic 404, &
> Auxiliary error 0.  (DBERR 13552)
> Can not continue with SELECT. (DBERR 97)
>
> I am assuming that this is generating a DBFIND and my where cause is not
> a key based on the return codes. However how do I get it to not do a
> DBFIND.
>
> The following is my select statement.
>
> SELECT DATABASE.TABLE.COLUMN
> FROM DATABASE.TABLE
> WHERE DATABASE.TABLE.COLUMN = 'QT';
>
> When I change the where clause to be
> WHERE DATABASE.TABLE.COLUMN >= 'QT';
>
> Everything works fine. Unfortunately the results are not what I want.
>
> Any help?
>
> Greg Rice
> Software Engineer
> Prevue Networks, Inc.
> Tulsa, OK
>


Don  Harrington                         Boeing Commercial Airplane Group
(206) 931-4457 voice                    P. O. Box 3707 M/S 5J-34
(206) 931-9085 FAX                      Seattle, WA  98124-2207
[log in to unmask]

These thoughts are owned by the person expressing them, and no one else!