<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New" size=2>Hi
All,</FONT></SPAN></DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New" size=2>Would some
one know of a one liner that would replace the third occurrence of a substring
within a string? For example:</FONT></SPAN></DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New" size=2>$string =
"?, ?, ?, ?";</FONT></SPAN></DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New" size=2>I want to
replace the third occurrence of "?" with "to_date(?, 'YYYY-MM-DD
HH24:MI:SS')".</FONT></SPAN></DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New" size=2>Thanks in
advance.</FONT></SPAN></DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=132431416-28062006><FONT face="Courier New"
size=2>Peter</FONT></SPAN></DIV>
<DIV> </DIV></BODY></HTML>