Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...
-- Q1 get the payment ID, Staff ID, rental ID and amount only for that payment where the rental ID is greater than rental ID of payment ID = 4 ...