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?
column1 column2 column3
cheer town greed
occupy serene addicted
provide astute recoup
able cool health
bright tanned abort
I was playing with something like the following to select words beginning with the letter 'A' without much luck:
SELECT column1, column2, column3
WHERE ??? LIKE 'A%'
Originally posted by vanekl
select column1 from yourtable where column1 like 'A%'
select column2 from yourtable where column2 like 'A%'
select column3 from yourtable where column3 like 'A%'
order by 1;
Thanks, vanekl! I'm ashamed I didn't think of trying that...