'***********************SQL EXAMPLES OF HOW TO  S E A R C H  F O R   S T R I N G S*****************

'IMPORTANT!!!! In .NET, we use the % to indicate a wildcard. In previous versions, we used *
'the * won't work in C#.Net inside a SQL statement!

'---This selects all matches of "j"
'SQL = "SELECT * From Customers WHERE LastName Like 'j%'"

'---This selects whatever they type in txtSearch
'SQL = "SELECT * From Customers WHERE LastName Like '" & Trim(txtSearch.Text) & "%" & "'"

'**************************************************************************************