Re: Select data prior to a character in a row?
Date: Mon, 7 Jan 2008 00:31:43 -0800 (PST)
On Jan 3, 7:38 pm, DP <dxpe..._at_gmail.com> wrote:
> I can select the data after the : with-
> select substr(name,instr(name,': ')+2,length(name)) from table;
btw the default if you don't specify a length for SUBSTR() is to return the remainder of the string, which is what you want here (and LENGTH(name) is wrong anyway), so that could be
select substr(name,instr(name,': ')+2) from table; Received on Mon Jan 07 2008 - 02:31:43 CST