Alphanumeric sort by number

dwgreen

One of the columns in a table has cell data that looks like this:
<a href="group_edit.cfm?eventid=5097&groupid=23451&round=2">Group 14</a>

So it's a link with the word Group and a number. When it sorts, I get this: Group 1 Group 10 Group 11 ... Group 19 Group 2 Group 20

What do we need to do in order to have Group 2 be placed after Group 1 in the sort, not after 19?

dwgreen

Looks like adding data-order column with just the group # does the trick, is there a better way?