INSTR('/')- SQL problem

From: <Sven.Berger_at_gmx.net>
Date: Wed, 08 Dec 1999 15:07:02 GMT
Message-ID: <82ls6i$8hq$1@nnrp1.deja.com>

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!

Thank you in advance
S. Berger

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