I am using vb5 /ADO2.1 with SQL Server 7 and opening a recordset with the following statement:
rs.open "SELECT surname FROM patient WHERE surname LIKE 'O''%'
ORDER BY surname",aDB, adOpenForwardOnly, adLockReadOnly
When I list the results the names are in the following order:
How do I only list the names with a ' in them. It appears to be ignoring the ' when sorting.