Skip to Content
avatar image
Former Member

SQL Casting

cast($[$38.14.1]as number(8,4))

this is giving internal error....Please help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 06, 2011 at 10:25 AM

    HI rupa,

    For what purpose ur using cast function.

    use this dollar sign rather than cast

    $[$38.14.Number]

    regards,

    Vignesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 06, 2011 at 09:52 AM

    Why you are using cast function, Simply use

    $[$38.14.Number]

    Thanks,

    Neetu

    Add comment
    10|10000 characters needed characters exceeded