Results 1 to 2 of 2

Thread: decimal point

  1. #1
    Join Date
    Feb 2002
    Posts
    16

    Unanswered: decimal point

    Hello
    I was wondering if you could help me.
    I am using Sybase SQL to do a select statement.

    I have a numeric field, ABC in one of my Sybase tables
    i.e. numeric(14,2).

    If I do a select on this field, I get values like 123.87, 345.56 etc.

    I would like to disregard the decimal point and end up with values 12387, 34556 etc (no rounding).

    Does anybody know whether or not there is a Sybase SQL command for this ?

    I would be most grateful if you could let me know
    Thanks in advance
    Tony

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Well, what about multiplying them all by 100?

    e.g.
    123.45 * 100 = 12345
    Thanks,

    Matt

Posting Permissions

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