Max with Text data

[dglinka]

I need to get the Max (or latest) Version by FullBuildID, problem is the FullBuildID is not a numeric value so when I use Max it returns a 0. Here is a sample of my data:

Product	Version	Full Build ID
A	16	16.0.00.0023.03
A	16	16.0.00.0020.02
A	16	16.0.00.0020.03
B	16	16.1.00.0040.57
B	7	7.5.00.0000.00

Desired output:

Product	Version	Full Build ID
A	16	16.0.00.0023.03
B	16	16.1.00.0040.57

thanks in advance for your assistance!

[Greg_Deckler · Accepted solution]

You could create a new column like this:

FullBuildNum = SUBSTITUTE([Full Build ID],".","")

Switch the column to Whole Number.