Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Representing decimal field as integer

Status
Not open for further replies.
Delphard

Delphard

Programmer
Jul 22, 2004
144
RS
How to represent decimal field as integer (in form without decimal digits and period) when value is actually integer, and leave decimal form when value is decimal?
:)
 
Sort by date Sort by votes
This would need to be handled via what ever UI is displaying the data.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
362
grnzbra
grnzbra
tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
284
tekpr00
tekpr00
NickyJay
  • Locked
  • Question
Convert date in Varchar field to datetime field - help please!
Replies
1
Views
107
drlex
drlex
RichardOneil
  • Locked
  • Question
Parsing a Name Field
Replies
1
Views
71
RichardOneil
RichardOneil
Lost500
  • Locked
  • Question
add uniqueidentifier field to existing table
Replies
1
Views
100
mutley1
mutley1

Part and Inventory Search

Sponsor

Back
Top