生成新的 FUNCTION GETNEWID(OLDSTR:STRING):STRING; BEGIN//OLDSTR:=FIELDBYNAME('MAX_FIELD').ASSTRING;NEWID:=STRTOINT(COPY(OLDSTR,3,3))+1;IF NEWID>99 THEN NEWSTR:='DB'+INTTOSTR(NEWID) ELSE IF NEWID >9 AND NEWID < 99 THEN NEWSTR:='DB0'+INTTOSTR(NEWID) ELSE NEWSTR:='DB00'+INTTOSTR(NEWID);RESULT:=NEWSTR; END;
FUNCTION GETNEWID(OLDSTR:STRING):STRING;
BEGIN//OLDSTR:=FIELDBYNAME('MAX_FIELD').ASSTRING;NEWID:=STRTOINT(COPY(OLDSTR,3,3))+1;IF NEWID>99 THEN
NEWSTR:='DB'+INTTOSTR(NEWID)
ELSE
IF NEWID >9 AND NEWID < 99 THEN
NEWSTR:='DB0'+INTTOSTR(NEWID)
ELSE NEWSTR:='DB00'+INTTOSTR(NEWID);RESULT:=NEWSTR;
END;
例如:DB001,DB002,CB001,CB002
怎么办呢?
请说的详细一点!
先行谢过!
select max(cast(right(field,len(field)-2) as int)) as MAX_1 from TablaName
用ASC码判断哪些是字母哪些是数字,定位,拷贝出数字字符,转换为数值型,增加1.