Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Mutliple Values in a Variable

    Use Dynamic query...

    DECLARE @auto varchar(20)

    DECLARE @industrial varchar(20),@SQL varchar(500)

    SET @auto='MD'','+'''RD'

    SET @industrial='ID'','+'''IW'

    Set @SQL='select * from Customer where CustomerClass in ('''+@ind+''')'

    Exec (@SQL)

Viewing post 1 (of 1 total)