Re: Easy question

Caroline Worrall (cworral_at_uswest.com) wrote:
: I am having a mental block on this.
 

: select <row_name> from <table>
: where <row_name> in ('A', 'B', 'C', etc. thru 'Z')

<snip>

The above syntax should work fine. However, if the field is more than one character, you may need to use either the substr or rtrim functions to get valid responses.

Example. select row_name from table

          where substr(row_name,1,1) in ('A','B'...'Z');

OR        select row_name from table
          where rtrim(row_name) in ('A','B'...'Z');

My answer is based on the assumption that <row_name> is a field you are searching on...otherwise ignore this response unless it does good otherwise. Received on Thu Jun 20 1996 - 00:00:00 CEST