mid string

[AngeldelaNoche]

I hope I just missed it somewhere, but related to the LEFT and RIGHT functions, is there a MID function?______MID(C,B,N) where C is a character expression, B is an integer numeric expression representing the starting position and N is an integer numeric expression representing the number of characters to select.____Example:____To split the parts of a phone number use LEFT, MID and RIGHT functions as follows:__LEFT(PHONE,3)__MID(PHONE,4,3)__RIGHT(PHONE,4)____Sample data:____PHONE PARTNO__8885551212 888__8885551212 555__8885551212 1212__

[kfleming]

The SUBS() function is the R&R equivalent of MID.____Kathleen__R&R Support