I want to do a LIKE clause in an SQL statement. What is the proper syntax if this if my informaiton.
I want to select personID, personName, personBuilding
From Table: main27
WHERE personName has the Name 'Smith' in it. Note that person Name is set up as: Last Name, First Name = Smith, John.
The query works fine in my access database, but I am trying to put it in a VB.net application and I can't get it to pull any records when there are 18. Any help would be grateful.
View Complete Post