sorting for MAX with field values like 04-100

[thawes]

I've got a table with a field that has values like 04-99 through 04-600. I need to sort for the max value which should come back as 04-600 (in my opinion..ha). However it always come back as 04-99. The field type is "char". I inhereted this schema so i'm doing the best I can.

Any help would be awesome. Thanks!

[Roger_Ramjet]

You are going to get a character sort so 9 is higher than 6 in 99v600.

try this

switch (strlen('$field'){
	case 4:
		$str = substr($field,0,3).'00'.substr($field,3,1);
		break;
	case 5:
		$str = substr($field,0,3).'0'.substr($field,3,2);
		break;
	default
		$str = $field;
	}

//then sort