- see footer for list info -<
I thought there was a SQL list, but I couldn't find it. I'm in a hurry, so I'd love it if someone could help.
I'm in a Stored Proc on MS SQL 2000 and I'm in the WHERE clause, trying to see if a column matches a list of integers. Something like: WHERE mycolname IN (@listOfIntegers) But that doesn't fly because my list of ints has to be a string. I tried... WHERE cast(fk_ActionID as varchar(40)) IN (@actionIDList) and that worked, but only if my @actionIDList only had one list member. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
