neural networks : Use string type comma separated in IN clause in sql

Showing posts with label Use string type comma separated in IN clause in sql. Show all posts

Showing posts with label Use string type comma separated in IN clause in sql. Show all posts

Wednesday, January 23, 2013

Use string type comma separated in IN clause in sql

declare @ProductIds nvarchar(50)='18,19'

SELECT * FROM products Where (',' + @ProductIds +',' LIKE '%,' + CONVERT(VARCHAR, ProductId) + ',%')

Subscribe to: Posts (Atom)