CONCATENATE and Make Unique Field

C

CCloud

I want to CONCATENATE two fields fn and ln.
But, if the newly created field already exists I want to add a number after
it.
For example.
John Doe becomes jdoe
Joe Doe becomes jdoe but since it is already in the database, it should be
jdoe1
 
Top