Problem with LIKE in Stored Procedures 1

[thelobe]

Can anybody please tell me what syntax to use when using the LIKE statement in Stored Procedures. This is my code, which doesnt work

CREATE PROCEDURE dbo.Test

@STR_IRC_DESC varchar(50) = 'b'

AS

SELECT * FROM TBL_IRCS WHERE IRC_DESCRIPTION LIKE % @STR_IRC_DESC %

GO

Please help
Thanks

 

[Katy44]

Is the IRC_DESCRIPTION a string? if so do you need it to be:

WHERE IRC_DESCRIPTION LIKE '%@STR_IRC_DESC%'

 

[dbomrrsm]

CREATE PROCEDURE dbo.Test

@STR_IRC_DESC varchar(50) = 'b'

AS

SELECT * FROM TBL_IRCS WHERE IRC_DESCRIPTION LIKE ('%'+@STR_IRC_DESC+'%')

GO

DBomrrsm

 

[Katy44]

Silly me! of course - I keep doing the same thing in all my SPs which explains why none of them work very well

 

[SQLSister]

Just remember only use like with a wildcard in the first character if you absolutely have to. Using it means that the indexes can't be used and it will slow things down considerably.

Questions about posting. See faq183-874