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