I have got a SQL statement that fetched data from the table 'authors' and places the data in a datgrid on the form.
This works fine,
Dim default As String "SELECT * FROM authors WHERE authorname = 'Ken Davies' "
The problem occurs when I introduce the LIKE command into the sql statement like this,
"SELECT * FROM authors where authorname LIKE 'Ken Davies' "
All I keep getting is an empty datagrid...
any suggestion much appreciated.