scientific notation and decimals

  • how do i display scientific notation and limit the # of dec places displayed. i what to have only (2) places before the "E" i am using this but cant get it to format like  i want. this code is in a ASP page / VBScript

    strQuery = " SELECT PU242= convert(varchar(100),cast( " & radio_Act_PU242 & "/SPECIFIC_ACTIVITY as float( 2) ) ) from wcodata..REF_NUCLIDES where RADIONUCLIDE = 'PU-242'" set rsConnREF_NUCLIDES = dbconn.Execute( strQuery)

    HELP !!

  • Do it client side, asp has more powerfull string manipulation features. Sql server is meant to store and send data, not manipulte it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply