title: How can i convert a price field which is currently varchar to a decimal so my prices will order correctly?
body: <p>I am using MYSQL.</p>
  
  <p>I have a varchar field which i incorrectly used for a price.  Now the ordering of this table will not work correctly putting anything over 1000 to the bottom of the list.  </p>
  
  <p>I need to convert this price field in an existing POPULATED database from varchar to decimal i guess?</p>
  
  <p>Any help would be appreciated.</p>