string query = "SELECT e.employeeId, e.firstName, e.lastName, e.position, e.contactNumber, el.email, el.password FROM employee e JOIN employeeLogin el ON e.employeeId = el.employeeId Where e.firstName LIKE @searchName% OR e.lastName LIKE @searchName% ";
cmd = new SqlCommand(query, _IsqlDataFunctions.GetConnection());
cmd.Parameters.AddWithValue("@searchName", txtAdminSearchName.Text);
I'm getting the error - "Incorrect syntax near the keyword OR"
i tried putting apostrophes around '@searchName%' but that returned nothing