>I want to search a string (say s1) in another string (say s2) and replace the search string (s1_ with another string (r1) .
>
>Is there a function?. I do not know much in VB. So please give the function or, the logic to do the above.
>
>I know VisualFoxpro. The same function is available in VFP as
>------strtran(s1,s2,r1)--------.
>
>What is it's equilant function in Visual Basic.
>Also suggest where can I clarify my doubts in SQL Plus.
>
>
>--Satya
In VB, there's no equivalent to VFP's strtran.
To search for a string in another string, use InStr().
You'll have to get the left portion with Left(), the right portion with Right() and put all 3 strings together: Left() & NewString & Right().
Instead of Left() and Right(), you can use Mid().
More code then VFP. :-(