Easy question

I am having a mental block on this.

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

I thought that the syntax was

where <row_name> in ('A'..'Z')

but that's not working so I guess it's wrong. I was sure there was a way to do this.

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.

If you've got a suggestion, I'd appreciate it very much.

Thanks,
Caroline
cworral_at_uswest.com Received on Wed Jun 19 1996 - 00:00:00 CEST