Not sure if this is the right place to post this but here goes....

I've got a field in my mysql db that contains both alpha and numeric values.

I'm trying to find the highest numeric value but using the below returns an alpha value.

Can I add a where clause so it only finds the max value of the numeric values in the field?

PHP Code:
SELECT MAX(MyField) AS MaxValue FROM MyTable