Link to home
Start Free TrialLog in
Avatar of Erik Hauser
Erik HauserFlag for United States of America

asked on

Remove a character from a number

Using Netezza,

I am trying to remove a '.' from a number.

Here is what I have:

45.01

What I want returned is:

4501

I have already tried the replace function with no success. Example: replace(DB_COLUMN, '.', '')

Can anyone help?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>replace function with no success. Example: replace(DB_COLUMN, '.', '')

What did it return?  Should work.

Try this:
db_column*100
replace isn't part of netezza's syntax by default

you'll need the sql extention toolkit which can be downloaded from IBM's support site
>>replace isn't part of netezza's syntax by default

I missed the Netezza piece.  Was only going by Oracle topic area.
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Erik Hauser

ASKER

Translate worked. Thank you!

My apologies for posting in the wrong area as there is no topic area for Netezza and Netezza somewhat closely mirrors Oracle.

Problem solved!