Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008

    Unanswered: Converting string to decimal - error

    Hi all,

    I have a stored proc that takes in parameters (from_threshold_value varchar(10), to_threshold_value(10). These need to be strings for another reason I won't go into.
    What I have is a HAVING clause in which I want to restrict the fact Aggr field based on the from and to thresholds the user types in.

    However, when I run it, I get the errorQL0420N - Invalid character found in a character string argument of the function DECIMAL.

    I don't understand why I'm getting this as the character string is typed in as it's a prompt so it's not as if I'm typing in something that can't be converted to a decimal. I've also tried using CAST as well.

    A simplified part of the SQL is below, any ideas would be appreciated. Thanks.


  2. #2
    Join Date
    Feb 2008
    What character string did you type in?

  3. #3
    Join Date
    Oct 2008
    Actually, just figured out the problem.
    It was my own daft logic!

    Thanks for the reply anyway.
    Last edited by chesl73; 10-07-08 at 19:29.

Posting Permissions

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