CONVERT in COMMANDS
Posted on 2006-06-12
Here's an intesresting question for you all!!
I'm using an Excel sheet as a data source for CR10 reports, and it has a field that sometimes may be less than 255 chrs for all records, or sometimes it may be more than 255. Crystal tends to check the field to set the data type, and tries to fix up the report and switch from String to Memo when encountering different length fields. I'd like to override this auto switching and force the field to be treated as memo regardless. I'm trying to write a COMMAND that will force something like...
SELECT CONVERT(MEmo, table.field)
but I know the syntax / function / is not correct for this. Any idea what it should be?