Post reply

Convert Varchar into numeric

  • June 28, 2004 at 11:23 pm

    #108535

    Hi

    I have a varchar value like 0.365 that i want to do calculations with. How do I turn this value into a datatype that I can calculate??

     

    How do I convert it??

     

    Regards Mattias

  • June 28, 2004 at 11:51 pm

    #512340

    Hi Mattias,

    Have you tried CONVERT(decimal,ColumnName). I used a decimal here as your exmaple in your post showed 0.365

    Anton

  • June 29, 2004 at 12:33 am

    #512348

    You might like to qualify 'decimal' with 'precision' and 'scale' arguments - eg decimal(9,5) gives you 9 decimal positions per number to play with - up to five of them to the right of the decimal point - check BOL for more details.

    The advantage here is that less memory is used (5 bytes, instead of the default 17 per decimal number)

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

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