Sybase 11 - Array Emulation or Replace character in deliminated string
I am pulling my hair out trying to produce a efficient solution to a problem
I need to generate a SQL 'IN' statement on the fly in a stored procedure,
I wanted to pass an array into the procedure to generate the IN statement
but I don't believe this can be done. So instead I need to pass in some deliminated
text, which cannot be comma deliminated! So please could some one suggest
how I should replace my deliminator in SQL with a new deliminator so I can
assign this to a new variable to be held in the IN statement!
I would appreciate any suggestions anybody has!
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center