How to update ClientCode ?

Sep 18 2019 1:46 AM

Hii to all,

I have a CilentsData table with column name RowId, CilentCode, ClientName, RegDate having more than

10 thousand records.

Now my problem is that I have to change the format of clientcode.

For example, if the ClientCode is NR121 then I have to change it to CR/121/2013.

Answers (4)

How to get 10 digit random number ?