Thread: SQL Syntax Help
View Single Post
  #1 (permalink)  
Old 01-30-09, 15:21
TML TML is offline
Registered User
 
Join Date: Jan 2009
Posts: 2
SQL Syntax Help

Is it possible to pass a comma delimited list of integers as a parameter into an IN function like this?

SELECT *
FROM MyTable
WHERE MyID IN (@MyVar)

'MyID' is an INT datatype and I'd like '@MyVar' to equal 1,2,3.

Many thanks in advance.

TML
Reply With Quote