easy solution

[jerepjohnson]

I would like to automatically/dynamically generate a new field from the social security field of our database that only contains the last five digits (and no hyphens). Is there an easy way to do this?

[mr_vodka]

Right ( Filter ( SSN; "0123456789" ); 5 )

[jerepjohnson]

Thanks a lot!