<< Larry: I'm not following exactly, but since you say you cannot use the DB field because you need to do text substitutions -- can you base your report on a temp table so you can do your substitutions in the temp table? >>
That lovely mail merge feature applies only to the non-db, non-variable version of the RTF memo field in the report writer, the one in which you "hard code" the memo contents when you create the report. I could put my info into a temporary table and print the report from there. That assumes I can apply SRPL against LONG VARCHAR columns. I just tried a quick test and got an INSUFFICENT BUFFER SPACE error. But I could write a DLCALL dll to allow this kind of substitution -- I think that system supports LONG VARCHAR and as an added plus I could take into account the fact that I'm dealing with RTF formatted code (which can make the substitutions a little more difficult). That's a good idea. So I'll add to my original question -- does anyone have experience using SRPL, or other replacement technique, against RTF text in a LONG VARCHAR column? -- Larry
