>I don't think there's an inStr function in FoxPro... although it's 99.9% likly that I'm mistaken.
>
>If there's not, is there a substitute function that I can use to do something like this:
>
>myString = "kdjfkjsf hjhuei oioiuwquiod john uhehjkdf hasjhdkh"
>:now I need something to detect the "john" in the string and return it and everything to the right of it including itself:
>
>myString = "john uhehjkdf hasjhdkh"
>
>Then I need a function to be able to cut the stuff off the string from the right.
>
>Are there Right() and Left() functions like in VB?
>
>Thanks!
John,
While you have your answer, one thing to note is that in some instances, the order of the parameters is reversed in VFP when compared to VB. If I recall correctly, INSTR() and AT() are one such case.
George
Ubi caritas et amor, deus ibi est