I'd like to create a query out of a comma delimited "search string"
egSearchstring = "Item1, Item2, Item3........."
sql = sql & "where [Data] like '*Item1*' or [Data] like '*Item2*' or [Data] like '*Item3*' "
I'm thinking of converting "searchstring" into a "sql string" and then writing
sql = sql & sqlstring
Your ideas on creating that "sql string" would be much appreciated. ( Working in VB6)