Re: String manipulations HELP!!!!

From: Ed Prochak <prochak_at_my-deja.com>
Date: Tue, 23 Jan 2001 06:03:21 GMT
Message-ID: <94j6r7$3q3$1@nnrp1.deja.com>

In article <94ibfc01e2a_at_drn.newsguy.com>, Dan White <dwhite_at_icimail.com> wrote:
> PLEASE HELP
>
> 2)I have a column which contains a http url string
>

http://ad.doubleclick.net/ad/main.cdnow/RP/SHARE/sound_popup.html;sz=250 x250;gid=;fid=85475;artid=;itmid=;formatid=;promoid=;kword=;collid=;fmta g=;adloc=top_center;lang=ENG;ord=535276841_0?
>
> In this string i am looking FID=85475 ( or what ever number is after
fid) this
> string can be anywhere in this string.
>
> PLEASE HELP
>
> Dan White
> programmer/analyst
>
> Dan White
> programmer/analyst
>
>

You just need to try the INSTR() function. I pronounce it as "in string" because it will return the location of a string within a string.

(You do keep your ORACLE reference handy, don't you?)

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support
440-498-3700 magic_at_magicinterface.com <<<WE MOVED!


Sent via Deja.com
http://www.deja.com/

Received on Tue Jan 23 2001 - 00:03:21 CST