Re: INSTR('/')- SQL problem

yitbsal_at_statcan.ca schrieb:

> > 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
>
> SQL> select instr('foo/bar', '/') from dual;
>
> INSTR('FOO/BAR','/')
> --------------------
> 4
>
> So I think QueryBuilder is the problem.
>

What about

select instr('foo/bar', chr(47)) from dual;

This should work if you find no other work around

Regards, Stephan

--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------