How can I modify code in Adobe ColdFusion Report builder to show only the last four digits of SSN?

Question

I have a report that shows the first four digits of SSN. However, I need to revise a report to show the last four. Nothing I have tried seems to give me the correct result. I either get an error in the report or null values.

ToString(Chr(45)  &  right(query.ssn1, 4))

I expect the output to be:

Donald Duck SSN (123456789); I need the output to be (6789).

Dashes are not necessary.