addition on alpha numeric field.. please help urgentt......................

[Former Member]

Hi friends,

I have a problem on addition for alpha numeric value.

I have a table with values could be like ex: A00300. I want to get the max of this field, and add 1 to it to get next maximum value for inserting a new record.

like : A00300 + 1 = A00301( my expected value).

Kindly reply this to me, pleaseaaaaaaaaaaaaaaaaa..

Robin......

[former_member365727 · Accepted solution]

Hi,

Use javascript and split the value to characters and numeric. Add the new value to numeric and concatenate this the character value , then populate into the table.

var a = 'A00';
var n = 300;
n = n+1;

var result = a+n; // value = A00301

Regards

Srikanth KV

[Former Member · Accepted solution]

solved myself