Hi Guys,
Im trying to retrieve a recordset from mt database using some sql..
Im managing to get some records but not all are getting retrieved.
Its supposed to be an alphabetic search and the user enters a letter of the alphabet and the database should return every record thats name starts with the letter..
Here is the sql string im using but its not quite right as i say t doesnt bring back all the records only some and wondered if anyone could advise.
Code:
MySQL="SELECT * FROM table1 where field_name Like '" & strname & "%' ORDER BY field_name ASC"