How to strip off an ending character, & 1

[ziggs]

Within the database, an intersection will appear as S Main St&First St& or 3rd St&Abel St&miscdata .

I need to make the true intersections like S Main St&First St Thus, how can I strip off the last & when & is the last character?

Thx

 

[lbass]

Not sure how "misc data" fits in here--can that be the end of the field? Anyway, if "&" can be the last character or the end of the street name can be the last character, then try:

if right({table.intersection},1) = "&" then
left({table.intersection},instrrev({table.intersection},"&")-1) else
{table.intersection}

-LB