Subject | split a string inside a stored proc or trigger |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2011-08-23T21:44:55Z |
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?
thanks!
sergio
[Non-text portions of this message have been removed]
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?
thanks!
sergio
[Non-text portions of this message have been removed]