Autoincrement and unique string values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a string datacolumn which needs to have unique
values.

If "Value" exists it needs to become "Value1".

The problem is that this is very slow when dealing with
large datatables and my alogirthm.

Is there a way to do this with autoincrement or some
other way??

many thanks.
 
IF you need this to be the key, as opposed to using an INteger, you can just
create an expression column that = Value + AutoincrementcolumnValue.

Expression columns make this pretty easy to do.
 
Back
Top