I am trying to write some scripts so that other users can update things as needed. I'm trying to make them as safe as possible, so I want to try and create variables that they change and don't touch the other code.
I have an in clause for this query that I'd like to be able to pass in multiple strings:
set @x = ('ABC-123','ABC-345','BGH-09876')
select * from table
where numberColumn in
I don't want to go over the top and create a huge script, just looking for a way to pass multiple strings to an IN clause later in the script.