Advertisement
Guest User

Untitled

a guest
Mar 1st, 2015
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. command.Parameters.AddWithValue("@searchTerm", searchTerm);
  2. command.CommandText = "SELECT [OA_Name] FROM [Operating_Authority_Table] WHERE [OA_Name] = [@%searchTerm%]";
  3.  
  4. command.Parameters.AddWithValue("@searchTerm", searchTerm);
  5. command.CommandText = "SELECT [OA_Name] FROM [Operating_Authority_Table] WHERE [OA_Name] = '%' + @searchTerm + '%'";
  6.  
  7. command.CommandText = "SELECT [OA_Name] FROM [Operating_Authority_Table] WHERE [OA_Name] LIKE '%"+ searchTerm +"%'";
  8.  
  9. "...WHERE [OA_Name] = '%' + @searchTerm + '%'";
  10.  
  11. "...WHERE [OA_Name] ALIKE '%' + @searchTerm + '%'";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement