Subject split a string inside a stored proc or trigger
Author Sergio H. Gonzalez
Hello, I'm using FB 2.5.

Having a string like "10 -20 10.2" it is possible to get 3 numeric
values = 10, -20 and 10.2?

That numbers are % to be applied to a currency field....

MY_CURR_FIELD + 10% - 20% + 10.2%

...meanwhile I'm trying to write a UDF, but I have none experience in
doing that...

Anyway, an UDF which receives two parameters (Amount: currency and
Discount: string)
and returns the calculated result would be the best solution?



[Non-text portions of this message have been removed]