Re: Substitute for SUBSTR

> It seems a bit odd that an ERP package does not allow the use of SUBSTR. Try this:

> SELECT
> T_1.*
> FROM
> T_1,
> T_2
> WHERE
> T_2.REF_POSID LIKE T_1.POS_NR||'%';
I thought of that, but apparently the "||" is an Oracle construct, not ANSI, and it is not allowed.

I haven't posted in the Oracle group for a few years. That Sybrand guy, wow, is he STILL an asshole? Received on Tue Jun 12 2007 - 06:57:05 CDT