perpetual_dream — 2010-01-14T06:55:16-05:00 — #1
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.
philiptoop — 2010-01-14T08:19:52-05:00 — #2
Not sure why you think it is not neat.
You could use the a function
Left(colname, 1) = 'A'
r937 — 2010-01-14T08:24:53-05:00 — #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'
philiptoop — 2010-01-14T10:11:14-05:00 — #4
Your right - I misinterpreted the question.