InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:00:57 GMT20http://www.teradata.com/teradataforum/Topic11760-9-1.aspxWelcome! :)Regards,AdeelMon, 09 Jun 2008 07:11:50 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11760-9-1.aspxThank you Adeel. It worked fine.Mon, 09 Jun 2008 07:03:59 GMTSujathahttp://www.teradata.com/teradataforum/Topic11760-9-1.aspxCAST is your friend:[font=Courier New]select cast(cast((123.4567 * 100) as integer) as numeric (9,2)) /100; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second.((123.4567*100)/100)-------------------- 123.45 BTEQ -- Enter your DBC/SQL request or BTEQ command:[/font]HTH Cheers.Carlos.Mon, 09 Jun 2008 04:27:56 GMTCarlosALhttp://www.teradata.com/teradataforum/Topic11760-9-1.aspxHello,You can use double casting...and INDEX function as below:SELECT SUBSTR(CAST('123.4567' AS VARCHAR(10)), 1, INDEX('123.4567', '.')+2)HTH.Regards,AdeelMon, 09 Jun 2008 03:25:21 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11760-9-1.aspxExample: 123.4567 i want to change/convert it to 123.45 and not 123.46.Please suggest some solution.Mon, 09 Jun 2008 03:18:48 GMTSujatha