I get a list of data similar to this CM,SL,BF
what I need to do is send to parameter in sql stored procedure.
my code looks similar to this.
@myList = '''WG'',''SM'''
a.propertyid in (@myList) ''this does not work, however I type
a.propertyid in ('WG','sm') that works and gets the results I need,
So could someone tell me what is wrong with @mylist line and what it needs to be to get this to work.