Subject | Re: [firebird-support] Re: Is such a CASE WHEN usage allowed? |
---|---|
Author | Mark Rotteveel |
Post date | 2012-04-12T09:31:19Z |
On Thu, 12 Apr 2012 09:28:48 -0000, "venussoftop" <venussoftop@...>
wrote:
and returns the values as individual rows. Better would be to not store it
like that at all as Arno indicated.
wrote:
> Thanks Mark I see the point now. Is there a function to convert theone
> string as returned by LIST() or in my field, because both are strings,
> automatically created and another manually createdNo there isn't. You could write a stored procedure that splits the string
> '24315,24371'
> to
> 24315,24371
and returns the values as individual rows. Better would be to not store it
like that at all as Arno indicated.