Does a Datatype like this exist?

BOA_Dev

Active member
Joined
Feb 16, 2007
Messages
32
Programming Experience
1-3
Im looking for a datatype similar to float where it displays the decimal places and doesnt display trailing 0s. However I would like it to have a 0 in the decimal place if its a whole number. So for example:

2 --> 2.0
2.10 -->2.1


Does something like this exist in sql2000? Thanks!
 
Details such as these are normally realised in the client app, or on display of the values, not their storage
 
Back
Top