Getting left and right expression values

[Kenneth Brody]

On 4/23/2012 10:30 PM, Stanley - stanlyn-com wrote:
> Hi Ken,
>
>> Use MID(), which is the equivalent of your substr() example.
> OK, yes I see that, and thanks...
>
> Now, what about the left and right functions?  How would you get those parts
> out of a string?
[...]

"left()" is simply "mid()" starting at position 1.

"right()" is a smidge more involved, but you can use len() to get the length 
of the field, and use length-n as the mid() starting position to get the 
rightmost "n" characters.

-- 
Kenneth Brody