Re: A simple Sql question

perhaps it would not be amiss to recreate your table to use a parent-child-reference. Besides you have to use a clever stringoperation, but your tables excerpt is too small for a filed SQL-string. Gimme more.

Abiy Alemu wrote:

> creating a unique index on a column of a table containing very
> large number of data rows. What I would like to do is a follows :
>
> Example : I have the following data
> staion_number station_reference power
>
> 0001 STATION1 150
> 0002 STATION2 250
> 0003 STATION2 253
> 0004 STATION2 350
> 0005 STATION3 400
>
> And I would like to, by an update statement have the following
> staion_number station_reference power
>
> 0001 STATION1 150
> 0002 STATION2 250
> 0003 STATION2-1 253
> 0004 STATION2-2 350
> 0005 STATION3-3 400
> or renaming in some other simple way.
>
> Is it possible to do it. If it is, how ?
>
> |-----------------------------------------------------------------------------|
> | If the only tool you have is a | Abiy Alemu abiy_at_biotec.jouy.inra.fr |
> | hammer, everything in the world | 9, avenue calmels |
> | seems like a nail.____________________| 92270 Bois colombes (France)________|
Received on Fri Jul 03 1998 - 09:37:53 CDT