• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

DECLARE used to define a list

I'm looking to set a list of variables and trying to get the syntax correct

DECLARE @DrugCodes varchar
SET @DrugCodes ???? ('4297','3721','3157')

I'm not sure ???? what to use here to define this?

Thanks
0
ghettocounselor
Asked:
ghettocounselor
  • 2
1 Solution
 
DoutorApedeutaCommented:
Hi, if I understand what you want, try this:

DECLARE @DrugCodes varchar
SET @DrugCodes = '(''4297'',''3721'',''3157'')'
0
 
ghettocounselorPharmacy Systems AdminAuthor Commented:
Ok, that executes.
so how to use that in a where statement?
I tried
> WHERE drug_code like @DrugCodes
as well as
> WHERE drug_code in @DrugCodes
but neither worked
0
 
DoutorApedeutaCommented:
You may build a dynamic query and execite it.

declare @cmd varchar(200)
set @cmd = 'SELECT * FROM Table WHERE drug_code IN(''4297'',''3721'',''3157'')'
exec(@cmd)
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now