Re: Easy question

Caroline Worrall wrote:
>
> I am having a mental block on this.
>
> select <row_name> from <table>
> where <row_name> in ('A', 'B', 'C', etc. thru 'Z')
> [...]
> where <row_name> between 'A' and 'Z' doesn't work because I get
> results that just start with a letter as well as entries that are
> just letters themselves.
> Hi Caroline,

you can use the following workaround:

select <row_name> from <table>
where ( <row_name> between 'A' and 'Z' ) and ( <row_name> like '_' );

The second part of the condition will filter out all the results that just start with a letter.

Marcus Wittke
r32643_at_email.sps.mot.com Received on Thu Jun 20 1996 - 00:00:00 CEST