Page 1 of 1

For varchar data min() Aggregator function

Posted: Tue Nov 09, 2010 11:42 pm
by nagarjuna900
Hi,

My source is sequential file with varchar data. while doing the min() aggregation to the varchar data the, the output am getting in the hexa decimal format.

How to avoid this?

Please give me the solution.


Thanks,

Posted: Wed Nov 10, 2010 12:34 am
by ray.wurlod
What are the input and output values? In particular what is the hex value, and can the input contain nulls?