on 04-30-2008 5:40 PM
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......
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.