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
max of two varchar
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Sort then use Remove Duplicates stage. For example, if sort is ascending, have Remove Duplicates pass only the last record in each group.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.