On Mon, 25 Jun 2007, Joshua wrote:
I have a column with the following values (example below)
5673
4731
4462
5422
756
3060
Are these numbers that will be used in calculations, or are they strings?
I want the column to display the numbers as follows:
56.73
47.31
44.62
54.22
7.56
30.60
Numeric(4,2) will do this. Also, whatever the UI you are using in your
application can make the translation from display format to storage format.
I have been playing around with string functions but cannot seem to figure
out a quick solution. Does anyone have any suggestions?
If they are strings, why not enter and store them with the decimal point?
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
