ALTER PROCEDURE [dbo].[search1] @customer Varchar(5000), @subject varchar(5000)
 
 AS BEGIN TRAN
  
SELECT     * 
FROM         Form
WHERE     (subject LIKE %@subject%) AND (customer = @customer)
 
  BEGIN COMMIT TRAN; RETURN 0 END BEGIN ROLLBACK TRAN; 
  RETURN 1;
   END 

quote:

---

Originally posted by moramoga

Hi guys,

This is kind of a noob questions, but here it goees. I have this store procedure

ALTER PROCEDURE [dbo].[search1] @customer Varchar(5000), @subject varchar(5000)
 
 AS BEGIN TRAN
  
SELECT     * 
FROM         Form
WHERE     (subject LIKE '%' + @subject + '%') AND (customer = @customer)
 
  BEGIN COMMIT TRAN; RETURN 0 END BEGIN ROLLBACK TRAN; 
  RETURN 1;
   END 

I know there is an error on %@subject%, can someone tell me the right way to do this?

---

quote:

---

Originally posted by dinakar

Just FYI that the search might not be efficient. Your use of wild cards before will prevent any indexes to be used..

---

quote:

---

Originally posted by LoztInSpace

quote:

---

Originally posted by dinakar

Just FYI that the search might not be efficient. Your use of wild cards before will prevent any indexes to be used..

---

Only on the subject. The customer stuff will use an index, which is likely to be a good choice anyway.

---