coba ditambahi dikit pake nama field di instr

select trim(substr(remark, instr(remark, 'CP') + 2)) from <nama_tabel>



--- In [email protected], FAJAR SIDIK <[EMAIL PROTECTED]> 
wrote:
>
> Thks bangnapi ... but kok error ...
>   errror: not enough argument for function ... pada instr nya ...
>   gimana yah ... :-D
> 
>  __________________________________________________
> Apakah Anda Yahoo!?
> Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik 
terhadap spam  
> http://id.mail.yahoo.com 
> 
> [Non-text portions of this message have been removed]
>







------------------------ Yahoo! Groups Sponsor --------------------~--> 
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~-> 

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups, 
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indo-oracle/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Kirim email ke