Question about ordering a text colum apart from alphabetically...

Last Post 13 Aug 2009 07:57 AM by kj2w2ndAccount. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
kj2w2ndAccount
New Member
New Member

--
13 Aug 2009 07:57 AM
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?

J


Acceptable Use Policy
---