Hi, I am trying to remove everything before the period in other words i only want to show the values that starts from the period. For instance 897.78 ==> 78 74.25 ==> 25 3657.256 ==> 256
well the code below only shows everything before the period but i want to show everything after the period
select volume, substring(volume from 1 for position('.' in volume) - 1) as column from MyTable ;
Try with: " SELECT volume, substring(volume from position('.' in volume) + 1) AS column FROM MyTable; "
Giuseppe.
-- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it