Check data if numeric or not

[len105]

I need to find out if the value in a text field started with a number or a character. How can I check this?

Please help!

 

[sem]

function startsFromNumber
return boolean
is
testnum integer;
begin
testnum := to_number(substr(<field>, 1));
return true;
exception
when others then
return false;
end;

Regards, Dima

 

[len105]

thanks a lot for your reply Dima. i've tried it and it worked!