Professional Web Applications Themes

Converting a varchar to money - Microsoft SQL / MS SQL Server

How do you convert/cast a varchar to money without dropping the decimal part? For e.g. DECLARE strNum VARCHAR(10) SET strNum = '0000053.10' SELECT CONVERT(MONEY,strNum) The result of the above script is 53.00. How would you get it to have the result 53.10? Thanks, Malia...

Sponsored Links
  1. #1

    Default Converting a varchar to money

    How do you convert/cast a varchar to money without
    dropping the decimal part? For e.g.

    DECLARE strNum VARCHAR(10)
    SET strNum = '0000053.10'
    SELECT CONVERT(MONEY,strNum)

    The result of the above script is 53.00. How would you
    get it to have the result 53.10?

    Thanks,
    Malia
    Sponsored Links
    Maligaya Guest

  2. #2

    Default Re: Converting a varchar to money

    Works fine here.

    --
    Tony Rogerson
    SQL Server MVP
    http://www.sqlserverfaq.com?mbr=21
    (Create your own groups, Forum, FAQ's and a ton more)


    Tony Guest

Similar Threads

  1. EARN MONEY| MAKE MONEY| HOME JOBS
    By enbee in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: July 16th, 10:08 AM
  2. converting varchar to double
    By Frederik Vanderhaeghe in forum ASP.NET Building Controls
    Replies: 3
    Last Post: April 21st, 08:29 AM
  3. Converting from data type varchar to data type money
    By schaudry in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: June 10th, 11:01 PM
  4. Converting data type varchar to data type money
    By schaudry in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 10th, 07:22 PM
  5. Error: "Syntax error converting the varchar value..."
    By Mike in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 21st, 10:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139