removing characters from a string

[itlbritguy]

I have a field which contains the city,ST information. How can I just retrieve the ST information? The state is always the 2 character state code assigned by the Post Office. I would need to remove everything up to and including the comma (",").

 

[CoSpringsGuy]

RIGHT(TRIM({FIELDNAME},2)



_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[CoSpringsGuy]

RIGHT(TRIM({FIELDNAME}),2)

I forgot a paren

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[itlbritguy]

Thanks for the help. It is appreciated