Parse out 2 characters starting from the right?

[dduva]

I have a field city_state which holds the city and state together. The state is always the last two characters, but the city is variable in length. Is there command or combination of commands I can use to parse out the state. Thanks in advance.

Devin

 

[DSummZZZ]

Try:

Say, city_state holds 'Las Vegas NV '

cState = RIGHT(ALLTRIM(city_state ), 2)
cCity = LEFT(city_state , LEN(ALLTRIM(city_state )) -2)

-or-
city_state holds 'Las Vegas, NV '

cState = RIGHT(ALLTRIM(city_state ), 2)
cCity = LEFT(city_state , At(",", city_state ) -1)

Dave S.

 

[dduva]

Thanks DSummZZZ. The first way works, there were no commas.

I wasn't thinking outside the box with the right() funciton.

Thanks again.