Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Substitute for SUBSTR

Substitute for SUBSTR

From: Buck <BuckTheManTurgidson_at_gmail.com>
Date: Tue, 12 Jun 2007 11:29:23 -0000
Message-ID: <1181647763.218131.239210@n15g2000prd.googlegroups.com>


I am working on a system (SAP) which uses Oracle, but its language disallows the use of any Oracle functions, we can just use generic SQL. I need to do the following SUBSTR in SQL, without using SQL, comparing '010' against '010001'. Is there a way to do this in generic SQL?

create table t_1 (
  pos_nr varchar2(3)
);

create table t_2 (
  ref_posid varchar2(10)
);

insert into t_1 (pos_nr) values ('010'); insert into t_2 (ref_posid) values ('010001');

commit;

Received on Tue Jun 12 2007 - 06:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US