Help in SQL query

[Brian Jorgenson]

I need to select records that begin with the letter A or B or C.. etc

Here is my select query:

SELECT '<a href="' & LINK & '"> ' & PLANNAME & '</a>' AS hyperl
FROM TABLE;
Where in here would I add A* to only pull PLANNAME records that start with A?

[Robin Tucker]

SELECT '<a href="' & LINK & '"> ' & PLANNAME & '</a>' AS hyperl
FROM TABLE
WHERE TABLE.PLANNAME LIKE 'A%'

I think ;)
"Brian Jorgenson" <bj********@charter.net> wrote in message
news:34**************************@posting.google.c om...

I need to select records that begin with the letter A or B or C.. etc

Here is my select query:

Where in here would I add A* to only pull PLANNAME records that start with

A?

[Brian Jorgenson]

Yes, you are right. This is what I have and it works great:

SELECT '<a href="' & LINK & '"> ' & PLANNAME & '</a>' AS hyperlink, PlanName AS Plan
FROM PLANNAME
WHERE ((([PlanName]) Like "*"));

"Robin Tucker" <id*************************@reallyidont.com> wrote in message news:<c6*******************@news.demon.co.uk>...

SELECT '<a href="' & LINK & '"> ' & PLANNAME & '</a>' AS hyperl
FROM TABLE
WHERE TABLE.PLANNAME LIKE 'A%'

I think ;)
"Brian Jorgenson" <bj********@charter.net> wrote in message
news:34**************************@posting.google.c om...

I need to select records that begin with the letter A or B or C.. etc

Here is my select query:

Where in here would I add A* to only pull PLANNAME records that start with

A?