SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: SQL Server data type ?
-
Oct 12, 2001, 14:01 #1
- 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??
-
Oct 12, 2001, 17:04 #2
- 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.
-
Oct 15, 2001, 07:00 #3
- Join Date
- Feb 2001
- Location
- Clearwater, FL
- Posts
- 3,615
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Worked...Sweet! Thanks
Bookmarks