"Middletree" <middletree@hottttttttmail.com> wrote in message
news:ezWrvURwHHA.3400@TK2MSFTNGP03.phx.gbl...
>I cannot seem to find anything in the Help or BOL about how to do to a
>select which would return rows if one of the fields has data which starts
>with a particular letter. Of course, I could use LIKE:
>
> select firstname, lastname
> from contact
> where lastname like (B*)
>
> But I'm thinking that will be pretty slow. There has to be a faster way.
> Any help appreciated.

wrote:
> Thanks. I can't believe I put that asterisk there, when I knew it should be
> percent sign. It's late.;)

On Jul 9, 12:46 pm, "Terri" <t...@cybernets.com> wrote:
> WHERE LEFT(LastName,1) = 'B'
>
> If I had to guess I would think this would be faster than using 'like' but I
> have never tested this.
>
> "Middletree" <middlet...@hottttttttmail.com> wrote in message
>
> news:ezWrvURwHHA.3400@TK2MSFTNGP03.phx.gbl...
>
> > I cannot seem to find anything in the Help or BOL about how to do to a
> > select which would return rows if one of the fields has data which starts
> > with a particular letter. Of course, I could use LIKE:
>
> > select firstname, lastname
> > from contact
> > where lastname like (B*)
>
> > But I'm thinking that will be pretty slow. There has to be a faster way.
> Any
> > help appreciated.

"Middletree" <middletree@hottttttttmail.com> wrote in message
news:ezWrvURwHHA.3400@TK2MSFTNGP03.phx.gbl...
> I cannot seem to find anything in the Help or BOL about how to do to a
> select which would return rows if one of the fields has data which starts
> with a particular letter. Of course, I could use LIKE:
>
> select firstname, lastname
> from contact
> where lastname like (B*)
>
> But I'm thinking that will be pretty slow. There has to be a faster way.
Any
> help appreciated.
>
>

On Jul 9, 1:46 pm, "Terri" <t...@cybernets.com> wrote:
> WHERE LEFT(LastName,1) = 'B'
>
> If I had to guess I would think this would be faster than using 'like' but I
> have never tested this.
>
> "Middletree" <middlet...@hottttttttmail.com> wrote in message
>
> news:ezWrvURwHHA.3400@TK2MSFTNGP03.phx.gbl...
>
>
>
> > I cannot seem to find anything in the Help or BOL about how to do to a
> > select which would return rows if one of the fields has data which starts
> > with a particular letter. Of course, I could use LIKE:
>
> > select firstname, lastname
> > from contact
> > where lastname like (B*)
>
> > But I'm thinking that will be pretty slow. There has to be a faster way.
> Any
> > help appreciated.- Hide quoted text -
>
> - Show quoted text -

> WHERE LEFT(LastName,1) = 'B'
>
> If I had to guess I would think this would be faster than using 'like'