>I would say test the length of the string, if its more than 254 then it came from a memo field. If you need to know the shorter ones too, then I would append a "memo - " to the front of the strings coming from the memo fields prior to importing them into the data set.

Thanks, the length in such case returns 2147483647. So, I will rely on that for the detection.