I've added a formatted search to a link field. This formatted search is executed when you add a picture to another field. We want this field to show the picture destination folder with the name of the picture.
The problem is that the type of the field is ntext and the data we want to introduce is varchar.
How can we show that data in the field?