TEST ALPHANUMERIC

From: (wrong string) Богомол Александр Анатольевич <bogomol_at_investbank.ru>
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;

...
...
END; If MyString is alphanumeric : result=0 If MyString is numeric : result=MyString Thanks Fred
Received on Tue Nov 27 2001 - 17:01:12 CET

Original text of this message