I have a SQL string that is giving me a problem and I'm not quite sure what is wrong. It's not returning any values, so I'm not sure if my syntax is incorrect. This is the SQL statement in question. Any and all help is greatly appreciated.
Thank you
With rst.Open "Select ExhibitorID,ExhibitorName From Exhibitor Where ExhibitorName LIKE " & "'" & Node.text & "*'", cnn, adOpenKeyset
End With Paul
paul_wilson74@hotmail.com
Thank you
With rst.Open "Select ExhibitorID,ExhibitorName From Exhibitor Where ExhibitorName LIKE " & "'" & Node.text & "*'", cnn, adOpenKeyset
End With Paul
paul_wilson74@hotmail.com