Home Forums SQL Server 7,2000 T-SQL Using variables within IN RE: Using variables within IN

  • June 11, 2003 at 2:54 am

    #460710

    Hello demos,

    quote:

    SELECT * FROM TableA WHERE ColumnB IN (@SomeVariable)

    and the variable can be = 1 or = 1,2,3 etc

    SELECT * FROM tablea WHERE ColumnB BETWEEN lower_bound and upper_bound

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]