Hi List,
Is there a function that lets u know the no of
occurance of a seperator in a parameter passed to a
SP.
What I need to do is , In one of my SP I get a
parameter string as
'10,11,12'
So I need to seperate 10 and insert it in a table and
then so the same for 11 and 12.
So I think I need to know how many ',' are there in
order to set loop condition and then get 10,11, and
12.
Any tips would be helpful,
Thanks,
Parag
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
MS Sql Server LazyDBA home page