Memo fields and scanning tables

[leibyj]

I have two questions:____1. Is there a way to convert memo fields into character fields? I need to use certain character functions on a memo field.____2. When running IIF statements, how do you make sure its checking every listing in the table?____Thank you

[kfleming]

The SQL version treats memo fields as character fields.____An IIF() calculation will be applied to each composite record in the report.____Kathleen__R&R Support

[leibyj]

What if you^re using Xbase edition?

[kfleming]

In Xbase there is not a way to convert from memo to character or to use character functions on memo fields.____Kathleen__R&R Support