How do I pull a text field in one table into a varchar field in another 
table? Do I need to convert the field? Also, this will truncate some
entries, should I explicitly truncate the returned entries?

thanks for your help