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
@vern ,
please try:
"xxx-xx-" + Right(ToString([fica]),4)
cheers,
mark
