Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Unanswered: Error converting data type varchar to numeric.

    Need Help trying to convert a vachar to a numeric value.


    select

    cconvert(numeric(12), Rec_Qty) as RecQty
    convert(char(35), Vnd_name) as Vendor Name
    from discounts

  2. #2
    Join Date
    Mar 2003
    Posts
    5

    Re: Error converting data type varchar to numeric.

    Originally posted by Icewood
    Need Help trying to convert a vachar to a numeric value.


    select

    cconvert(numeric(12), Rec_Qty) as RecQty
    convert(char(35), Vnd_name) as Vendor Name
    from discounts
    I can't tell you exactly but I would look at the ISNUMERIC and CAST functions. I only ever use CONVERT for dates, CAST for everything else.

Posting Permissions

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