Select all the records that start with certain letters

Databases
1

Hello,

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.

Thanks.

2

Not sure why you think it is not neat.

You could use the a function
Left(colname, 1) = ‘A’

3

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’

4

Your right - I misinterpreted the question.