Kwisatz78 (3/21/2013)
My question is, in this case, would that be the best way to code this or would splitting the string first and placing it in a temp table before being queried be better coding practice?
See this is the general/frequently used approach while dealing with this kind of split string query.
You query performace will be dependent on how much string(data) will get splitted and join back to another table.
and above of this , this function will get called for every record.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)