I need help with an SQL Statement in which I am using Like. I would like to Select all records where the FirstName starts with the letters "ch"
However, in the SQL statement I need put the letters "ch" using a variable named SearchPhrase.
The SQL Statement in the code window selects for me all records which the letter combination "ch" occurs any where in the FirstName Field. I would like to Select only records where FirstName field starts with "ch"
Dim strSelectClients As String
Dim searchPhrase As String
searchPhrase = "ch"
strSelectClients = "Select * from Clients where FirstName like '%" & searchPhrase & "%' "