I have a table that has values in a column like '001', '002', 'P12', 'P01', '007', etc... The column itself is a varchar(5) and either has a value of three digits (###) or P followed by two digits (P##).
The trick is, I need to return these rows ordered with the P-values first. So P01 would come before P04, P05, P12, etc... Followed by the 001, 003, 015 values.
Any idea how might I go about this?