Post reply

SQL Query Analyzer displays int fields as money.

  • January 4, 2005 at 7:30 am

    #87256

    I have a table that has an id column that is a user defined type (which is an int really). When I query the table in the Query Analyzer, the field is display as money. e.g.

    1,234.00

    1,235.00

    1,236.00

    However it only does this when I'm typing the query by hand. If I just right click on a table in the Object Browser and click Open, it displays fine. e.g.

    1234

    1235

    1236

    Any ideas about this odd behavior?

    Arthur.

    Beginner Biker Adventures Blog

  • January 4, 2005 at 3:09 pm

    #535871

    You can try the following: 

    Go to "Tools" ----> "Options" 

    Click on the Connections tab.  Un-check "Use Regional settings when displaying currency, number, dates, and times". 

    I need that setting on as the db I am working with displays money as an integer.  To overcome the problem with actual integers, I have to convert those values to varchars. 

    CONVERT( varchar(10), mstr.appl_id) AS appl_id

    I wasn't born stupid - I had to study.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply