LIKE statement in Report Builder 3 with parameters

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

LIKE statement in Report Builder 3 with parameters

Author

Topic

nferri
Starting Member

5 Posts

Posted - 2013-02-15 : 15:13:08

Hi, I am trying to add a LIKE statement to a query in report builder 3.0 with a parameter like the one below. It allows the user to input an ID and returns records that have that id in their list of IDs by using the like statement with wildcards.

SELECT
CORRIDOR.OBJECTID
,CORRIDOR.STATUS
,CORRIDOR.DIMENSION
,CORRIDOR.WIDTH
,CORRIDOR.ID
FROM
CORRIDOR
WHERE ID LIKE '%' + @ID + '%'

I get an error "Conversion Failed when Converting the varchar value '%' to data type int"

I am not sure why the wildcard is converting to int. my @ID parameter is text. Please help. Thanks!

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-15 : 15:51:36

May be the ID column is INT? Try this to be safe on all sides, and then you can try removing one side or the other if you like to:

WHERE CAST(ID AS VARCHAR(32)) LIKE '%' + CAST(@ID AS VARCHAR(32)) + '%'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources