When I use this code
@stlocation= 3713 Yanceyville st Greensboro NC
@UseST = NC
REPLACE(@stlocation, @UseST, '')
I want to get
3713 Yanceyville st Greensboro
However-- I get
3713 Yaeyville st Greensboro
It removes the NC not only from the back of the string but also from the STREET!!
Can someone tell me how to remove only from the back of the string? This same thing could happen if a street name is Virginia ST and the state entered is Virginia.. It would take virginia off of both the state and the street!!