HI Melvin:
On Thu, Sep 24, 2015 at 2:51 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
Postgresql has a translate function:
Did you read the ( quoted at the bottom of the reply you sent ) message you were replying to? It contained a working sample using exactly this translate. ;->
I'll leave that to you to work out, but additional functions ofYou would then need a little further processing to determine the tens, hundreds, etc.
strpos(string, substring)
substr(string, from [, count])length(string)
Do not forget replace, shorter, easier.
Francisco Olarte.
