SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Xbox why have you forsaken me? moospot's Avatar
    Join Date
    Feb 2001
    Location
    Clearwater, FL
    Posts
    3,615
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server data type ?

    I am trying get the shoe sizes in my database to display correctly.

    They are now set to text so they display out of order, like so:

    10
    11
    12
    7.5
    8
    8.5

    Now, I've tried a few different data type (numeric, decimal, etc) but can't seem to get the result I want.

    I need one decimal point in the half sizes and no decimal points on the whole sizes.

    Can someone please help me ??

  2. #2
    SitePoint Wizard
    Join Date
    Jan 2001
    Location
    Milton Keynes, UK
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try using a decimal with precision:3 and scale:1.

  3. #3
    Xbox why have you forsaken me? moospot's Avatar
    Join Date
    Feb 2001
    Location
    Clearwater, FL
    Posts
    3,615
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Worked...Sweet! Thanks


Bookmarks

Posting Permissions

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