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