Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

SQL Select Where equals array


I have a list of questions in a table with an ID field that numbers them

I have to take a list of numbers that could be up to 200 long and have to selectthose questions

Using eg Select * From Questions Where ID = 4 Or ID = 5 Or ID = 33............
would be far to cumbersome.
Is there a way to use my string "4,5,33......" in the SQL statement as an array
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon