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!
2 --> 2.0
2.10 -->2.1
Does something like this exist in sql2000? Thanks!