Where clause with LIKE operator

Question

Hi All,

DECLARE	@ST	VARCHAR(500)
SET		@ST = '01091,01094'

CREATE TABLE #TEMPA
(
	ID	INT,
	ST	VARCHAR(50)
)

INSERT INTO #TEMPA VALUES ( 1, '01091,01092' )
INSERT INTO #TEMPA VALUES ( 2, '01091,01092,01093' )
INSERT INTO #TEMPA VALUES ( 3, '01092,01093' )

SELECT	'''%'+LEFT(@ST, 5)+'%'''

SELECT	*
FROM	#TEMPA
--WHERE	ST LIKE '%01091%'
WHERE	ST LIKE '''%'+LEFT(@ST, 5)+'%'''

DROP TABLE #TEMPA

Can anybody help me with the correct where clause with LIKE operator, please?

Thanks

Kumar

---

Please do let us know your feedback. Thank You - KG, MCTS

Answer 1

Hi

See below example :

SELECT * FROM AUTHOR
 WHERE NAME LIKE '%a%' OR (AUTHOR_ID >= 5 AND AUTHOR_ID <= 10); 

For more example :

http://searchsqlserver.techtarget.com/feature/Filtering-with-the-WHERE-clause

---

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

Answer 2

I cannot find it!!

---

Please do let us know your feedback. Thank You - KG, MCTS

Answer 3

my where is something like this:

WHERE	ST LIKE '''%'+LEFT(@ST, 5)+'%'''

can you help me with my query please?

---

Please do let us know your feedback. Thank You - KG, MCTS

Answer 4

WHERE	ST LIKE '%'+LEFT(@ST, 5)+'%'

---

Please do let us know your feedback. Thank You - KG, MCTS

Answer 5

You seem to have too many quotes. Try:

WHERE     ST LIKE '%'+LEFT(@ST, 5)+'%'

Although that is not a very efficient way to search for data.

---

Erland Sommarskog, SQL Server MVP, [e-mail]