Please i have two fields and want to update one with a unique random generated numbers of. In all the unique numbers should be 9 and ends with the first letter in the other table. This is what i have;

Update members
set IDNumber = 'MDC-' || ABS(360 + RANDOM () % 283645791 || '-' || SUBSTR(branchcode,1,1)).

this words but am not sure the random numbers are unique and also the count of the numbers are all not to 9.

Urgent reply .