Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008

    Unanswered: remove spaces from a column

    I have a column of UPC codes. Some of the UPC codes contain spaces. I need to remove the spaces. What is the query, please? Thank you.

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Have a look at the REPLACE function in MySQL. This will help you with what you are looking to achieve here.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts