TEST ALPHANUMERIC
From: (wrong string) Богомол Александр Анатольевич <bogomol_at_investbank.ru>
Date: Tue, 27 Nov 2001 18:01:12 +0200
Message-ID: <9455EAF0C99FD111B85B0060B067688A05022BBF_at_E40>
Date: Tue, 27 Nov 2001 18:01:12 +0200
Message-ID: <9455EAF0C99FD111B85B0060B067688A05022BBF_at_E40>
Hi ! Hope it helps. MyString VARCHAR(10); BEGIN begin Res:=to_number(MyString); result=MyString; exception result=0; end;Received on Tue Nov 27 2001 - 17:01:12 CET
...
...
END; If MyString is alphanumeric : result=0 If MyString is numeric : result=MyString Thanks Fred