Martin, > Not true! Selection uses external format data. Where a field with a conversion code is compared with a > constant, the constant is converted to internal form prior to the comparison. The LIKE operator works the > other way around and converts the data to its external form as it couldn't work any other way.
I think Mats is correct. The 'field' in question is an EVAL expression, so doesn't have its own conversion code unless you explicitly state it using the CONV keyword. Hence the confusion over the result. Brian ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
