6 Replies Latest reply on Jun 5, 2007 11:14 AM by cf_dev2

    delete spaces

    JohnGree Level 1
      Hi i have a string of text and numbers which i want to insert into a table colum


      (ApID)
      values
      ('#ClubID##First##Sur##Phone#')

      but i need to remove any spaces that may occur how can i do this inside the insert query?