Crystal Report Memo Field
The first line below works in a command in Crystal Reports. What I want to do is take the word "Source" and concatenate it to the slpartsource.sourceindex field. the first line below works. But the "Find1" field is "Memo" field. I want it to be a text field. What I want to do is to be able to see the field in the database so I can join "Find1" field to another field. Any help would be greatly appreciated. Thank you in advance.
select concat('Source',sourceindex) as Find1,* from slpartsource
Left(slpartsource.Find1,40) as Find10
Read responses in techsupportforum.com