If this table has a primary key, you could select the duplicate names and primary key then, using a UDF in the update where clause, increment the suffix.
>I have a Table in Which there is a column named Account.
>
>There are cases where there are some repeated Data in this column for example james in as given Below.
>
>
>James
>Charles
>Joseph
>James
>Sarfarz
>James
>
>
>I need to update the repeated value as
>
>
>James
>Charles
>Joseph
>James-2
>Sarfarz
>James-3
>
>
>or
>
>
>James-1
>Charles
>Joseph
>James-2
>Sarfarz
>James-3
>
>
>Is there any way to do so using SQL or some code. I could do using Scan Endscan Loop but will Take Lot of time where the table size is big and volume of Data is large
>
>Thanks
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/Never explain, never complain (Queen Elizabeth II)