DECLARE @EvaluationID int, @SearchString char(100) SET @EvaluationID = 23 SET @SearchString = '%quest%' SELECT DISTINCT( q.QuestionID ), q.QuestionText, d.html_description as AnswerDisplay FROM Questions q INNER JOIN Types t ON q.QuestionTypeID = t.TypeID INNER JOIN DataGridCode d ON t.TypeID = d.TypeID WHERE q.QuestionText LIKE @SearchString ORDER BY q.QuestionIDSample #2
DECLARE @EvaluationID int, @SearchString char(100) SET @EvaluationID = 23 SELECT DISTINCT( q.QuestionID ), q.QuestionText, d.html_description as AnswerDisplay FROM Questions q INNER JOIN Types t ON q.QuestionTypeID = t.TypeID INNER JOIN DataGridCode d ON t.TypeID = d.TypeID WHERE q.QuestionText LIKE '%quest%' ORDER BY q.QuestionIDThank you,