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?
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?
Databases
Last Comment
Erik Hauser
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
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.
I missed the Netezza piece. Was only going by Oracle topic area.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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!
My apologies for posting in the wrong area as there is no topic area for Netezza and Netezza somewhat closely mirrors Oracle.
Problem solved!
What did it return? Should work.
Try this:
db_column*100