[SOLVED] query for specific first character from field

[jonaHill87]

Hi all. I'm trying to query a last name field in my table beginning with specific letters. So for example if I want to retrieve names beginning with "b", I need to query the first character of the field for each record. I thought I could use "LIKE" but correct me if I'm wrong, "LIKE" searches for the first occurance of "b" in the string.

[Barand]

WHERE name LIKE 'b%'

 

will find those beginning with "b"

 

 

WHERE name LIKE '%b%'

 

will find those containing "b"

[jonaHill87]

Ah. Ok, great. Thanks, I was using the second percentage one. Thanks.