How to get the part of the string?

From: (wrong string) Богомол Александр Анатольевич <bogomol_at_investbank.ru>
Date: Tue, 27 Nov 2001 15:24:20 +0200
Message-ID: <9455EAF0C99FD111B85B0060B067688A05021793_at_E40>


In additional:
[Quoted]  I need to use retrieved numbers for calculating.  So such sql doesn't work
a= 'abcdef';

 Select to_number(substr(a,instr(a,'&')+1)) from dual;

When '&' is missed, I get an error.

  • Исходное сообщение----- От: Богомол Александр Анатольевич Помещено: 27 ноября 2001 г. 15:16 Помещено в: tools Предмет: How to get the part of the string? Тема: How to get the part of the string?
		In additional:
		 I need to use retrieved numbers for calculating.
		 So such sql doesn't work
		a= 'abcdef';

		 Select to_number(substr(a,instr(a,'&')+1)) from dual;

		When '&' is missed, I get an error.
Received on Tue Nov 27 2001 - 14:24:20 CET

Original text of this message