|
|
Posted by Apaxe2000 on 07/03/07 03:11
On Jun 21, 8:05 pm, "jlaust...@gmail.com" <jlaust...@gmail.com> wrote:
> On Jun 21, 12:44 pm,Apaxe<apaxe2000Milh...@gmail.com> wrote:
>
> > In the database i have a table with this information:
>
> > key_id => 1
> > key_desc => 43+34+22+12
>
> > I want sum the values in key_desc. Something like:
>
> > SELECT key_desc FROM table
>
> > But the result of the select was "111" and not "43+34+22+12".
>
> > Is this posible?
>
> Are you saying that the key_desc is a char() field with the value
> "43+34+22+12" in it? If that's the case then this IS possible, but
> the code is gonna make your head hurt a little bit :) Let me know and
> I'll be happy to work with you on it.
>
> Joshua
Hello, Joshua.
Yes, key_desc is a char() field. And i need to extract de sum of the
string. In this case, the value "111".
Thank you.
Navigation:
[Reply to this message]
|