Convert Fica string

[vern]

I want to convert the fica string to xxx-xx-1234 to only show the right most 4 digit of the fica number for security purposes

[MarqueeCrew · Accepted solution]

@vern ,

 please try:

"xxx-xx-" + Right(ToString([fica]),4)

 cheers,

 mark