HI Melvin: On Thu, Sep 24, 2015 at 2:51 PM, Melvin Davidson <melvin6...@gmail.com> 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. ;-> > > You would then need a little further processing to determine the tens, > hundreds, etc. > > I'll leave that to you to work out, but additional functions of > strpos(string, substring) > substr(string, from [, count]) > length(string) > Do not forget replace, shorter, easier. Francisco Olarte.