max of two varchar

consulting · Post by **consulting** » Tue Jun 16, 2009 2:08 pm

Hi
I have a feild XX
Wich is of varchar datatype has the values
like
1000007
562369p
12-52-00
1-po-023
90-op-88
I have to take max of it

Thanks

nagarjuna · Post by **nagarjuna** » Tue Jun 16, 2009 3:42 pm

According to you which is max of below values and why ??

1000007
562369p
12-52-00
1-po-023
90-op-88

ray.wurlod · Post by **ray.wurlod** » Tue Jun 16, 2009 4:45 pm

Aggregator stage to calculate MAX.

Sort then use Remove Duplicates stage. For example, if sort is ascending, have Remove Duplicates pass only the last record in each group.