VB 6 SQL problem ???
-
Ok this is my code Dim sqlstr as String sqlstr = "SELECT * FROM Products WHERE PrdName Like 'MS'" Data1.RecordSource = (sqlstr) Data1.Refresh the string "MS" exists in so many records but the result is not what it should be ??? It returns 0 records found. any ideas ??? Thanx
-
Ok this is my code Dim sqlstr as String sqlstr = "SELECT * FROM Products WHERE PrdName Like 'MS'" Data1.RecordSource = (sqlstr) Data1.Refresh the string "MS" exists in so many records but the result is not what it should be ??? It returns 0 records found. any ideas ??? Thanx
Try this... sqlStr = "SELECT * FROM Products WHERE PrdName LIKE 'MS%'"
Paul Watson wrote: "At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote: "Don't sweat the petty things, and don't pet the sweaty things."