I have a field named 'Page_Spread' which is an Integer data type. I am casting it to a CHAR(4), but upon sorting, it is not sorting in the correct way. EG 1,2,11 IS being sorted 1,11,2. The reason is obviously because I am converting to a string which I need to do for other reasons, but does anyone know how to convert to string & stll have it sorted in the correct manner??