Subject Re: [firebird-support] Re: Is such a CASE WHEN usage allowed?
Author Mark Rotteveel
On Thu, 12 Apr 2012 09:28:48 -0000, "venussoftop" <venussoftop@...>
> Thanks Mark I see the point now. Is there a function to convert the
> string as returned by LIST() or in my field, because both are strings,
> automatically created and another manually created
> '24315,24371'
> to
> 24315,24371

No there isn't. You could write a stored procedure that splits the string
and returns the values as individual rows. Better would be to not store it
like that at all as Arno indicated.