Pulling from a database starting with one letter?

[Guest]

Hi,
I'm trying to sort a directory alphabetically using ASP
How can I pull from the database but just pull out
categories starting with one letter?
At the moment I am just using

ORDER BY strCategory ASC

Which pulls them all and lists alphabetically,
but how do I just pull all categories starting with A?
and then a separate one pulling categories starting
with B, etc. etc.

Many thanks.

 

[Peter Danes]

Add a WHERE clause?

WHERE LEFT(strCategory,1)="A"

Pete

 

[Arvin Meyer [MVP]]

Use a where clause with the "like" keyword:

WHERE [Field Name] Like "A*"

using asp and html, you'll need to use a % sign in place of the asterisk.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thank you, that was exactly what I wanted.
I also see I can also pull out individual categories in the same way.
Going to be very useful for me.

Thanks again.

Use a where clause with the "like" keyword:

WHERE [Field Name] Like "A*"

using asp and html, you'll need to use a % sign in place of the asterisk.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Hi,
I'm trying to sort a directory alphabetically using ASP
How can I pull from the database but just pull out
categories starting with one letter?
At the moment I am just using

ORDER BY strCategory ASC

Which pulls them all and lists alphabetically,
but how do I just pull all categories starting with A?
and then a separate one pulling categories starting
with B, etc. etc.

Many thanks.