Re: INSTR('/')- SQL problem

In article <82ls6i$8hq$1_at_nnrp1.deja.com>,   Sven.Berger_at_gmx.net wrote:
> Hello SQL users,
>
> I would like to use the INSTR function to get the position of a char.
> The char to look for is the slash "/". When I write a statement like:
> "INSTR(mystring,'/')" it seems to me, that the slash will be ignored.
Is
> there something like a special char before the slash when I want to
use
> it in INSTR? When I make "INSTR(mystring,'//') one of the slashes is
> cut by the oracle querybuilder!
>
>

It works for me in SQL Plus 8.0.

SQL> select instr('foo/bar', '/') from dual;

INSTR('FOO/BAR','/')

                   4

So I think QueryBuilder is the problem.

In any case, the other way to escape special characters in Oracle is by using the ESCAPE operator. But I don't know if that's available in QueryBuilder.

Salaam Yitbarek

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 13:07:17 CST