Pulling from a database starting with one letter?

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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12003-pulling-from-database-starting-one-letter.html
At the moment I am just using
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003

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.



*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Add a WHERE clause?

WHERE LEFT(strCategory,1)="A"

Pete



"UKSBD" pí¹e v diskusním pøíspìvku
news:A2B95EC7-7E4C-4A48-BBEA-E5799DF8EFA1@microsoft.com...
> Hi,
> I'm trying to sort a directory alphabetically using ASP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003
> How can I pull from the database but just pull out
> categories starting with one letter?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003
> 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.
>
>

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

"UKSBD" wrote in message
news:A2B95EC7-7E4C-4A48-BBEA-E5799DF8EFA1@microsoft.com...
> Hi,
> I'm trying to sort a directory alphabetically using ASP
> How can I pull from the database but just pull out
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003
> with B, etc. etc.
>
> Many thanks.
>
>

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.


"Arvin Meyer [MVP]" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003
>
> "UKSBD" wrote in message
> news:A2B95EC7-7E4C-4A48-BBEA-E5799DF8EFA1@microsoft.com...
> > Hi,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12003
> > 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.
> >
> >
>
>
>