Eu,
Israel Aéce estive a procurar por uma função para validar um determinado código. Logo, bastou-me fazer uma busca no Google e encontrar uma função (em T-SQL ou PL-SQL) que faça isso: (um trecho dela)
pCmc7 CHAR(34) := trim(xcmc7);
IF instr('0123456789',substr(pcmc7,2,1))>0
AND instr('0123456789',substr(pcmc7,3,1))>0
AND instr('0123456789',substr(pcmc7,4,1))>0
AND instr('0123456789',substr(pcmc7,5,1))>0
AND instr('0123456789',substr(pcmc7,6,1))>0
AND instr('0123456789',substr(pcmc7,7,1))>0
AND instr('0123456789',substr(pcmc7,8,1))>0
AND instr('0123456789',substr(pcmc7,9,1))>0
AND instr('0123456789',substr(pcmc7,11,1))>0
AND instr('0123456789',substr(pcmc7,12,1))>0
AND instr('0123456789',substr(pcmc7,13,1))>0
AND instr('0123456789',substr(pcmc7,14,1))>0
AND instr('0123456789',substr(pcmc7,15,1))>0
AND instr('0123456789',substr(pcmc7,16,1))>0
AND instr('0123456789',substr(pcmc7,17,1))>0
AND instr('0123456789',substr(pcmc7,18,1))>0
AND instr('0123456789',substr(pcmc7,19,1))>0
AND instr('0123456789',substr(pcmc7,20,1))>0
AND instr('0123456789',substr(pcmc7,22,1))>0
AND instr('0123456789',substr(pcmc7,23,1))>0
AND instr('0123456789',substr(pcmc7,24,1))>0
AND instr('0123456789',substr(pcmc7,25,1))>0
AND instr('0123456789',substr(pcmc7,25,1))>0
AND instr('0123456789',substr(pcmc7,26,1))>0
AND instr('0123456789',substr(pcmc7,27,1))>0
AND instr('0123456789',substr(pcmc7,28,1))>0
AND instr('0123456789',substr(pcmc7,29,1))>0
AND instr('0123456789',substr(pcmc7,30,1))>0
AND instr('0123456789',substr(pcmc7,31,1))>0
AND instr('0123456789',substr(pcmc7,32,1))>0
AND instr('0123456789',substr(pcmc7,33,1))>0
THEN ......
De "lambuja" já aprendi como verificar se o caracter é ou não um número. :P
Posted
10-11-2004 14:49
por
Israel Aece e Joao Paulo Carreiro