Hi,

I've a similar question to the one I asked at http://www.dbforums.com/t982096.html. Given the following columns and their corresponding entries, how do I select only words beginning with a certain letter?

I was playing with something like the following to select words beginning with the letter 'A' without much luck:
I don't know what to put in place of ???.

Hope someone can enlighten me

TIA

select column1, column2, column3
from words
where column1 like 'A%'
or column2 like 'A%'
or column3 like 'A%'

However, you'd get the following back

occupy serene addicted
etc.

If you only want addicted, astute, able and abort back then
I'd suggest three queries.

select column1
from words
where column1 like 'A%'

select column2
from words
where column2 like 'A%'

etc.

select column1 from yourtable where column1 like 'A%'
union
select column2 from yourtable where column2 like 'A%'
union
select column3 from yourtable where column3 like 'A%'
order by 1;

Thanks, vanekl! I'm ashamed I didn't think of trying that...