How can I select all the names that start with the letters from A to E... I know this can be done by using LIKE 'a%' or like 'b%' or like 'c%' .... But is there any neater way.
Not sure why you think it is not neat.
You could use the a function Left(colname, 1) = 'A'
philip, your solution is somewhat incomplete, it should be this --
... WHERE LEFT(colname,1) IN ('A','B','C','D','E')
or this --
... WHERE LEFT(colname,1) BETWEEN 'A' AND 'E'
Your right - I misinterpreted the question.