Good morning, and a VERY happy New Year to ALL!
I don't know if this is a question more suitable for the SQL forum, but I figured I would try here first.
I want to search a field in an SQL database for all the rows that begin with a particular leter! For example, if the following is the rows in a column . . .
alpha
adam
adrian
betta
blue
bat
. . . and the search is "a," I only want alpha, adam, and adrian to be returned. If the search is "b," I want betta, blue, and bat.
Any help? Thanks!
The Youthman
I don't know if this is a question more suitable for the SQL forum, but I figured I would try here first.
I want to search a field in an SQL database for all the rows that begin with a particular leter! For example, if the following is the rows in a column . . .
alpha
adam
adrian
betta
blue
bat
. . . and the search is "a," I only want alpha, adam, and adrian to be returned. If the search is "b," I want betta, blue, and bat.
Any help? Thanks!
The Youthman