Re: simple SQL question

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