Getting rid of blank spaces in a field in SQL
Posted on 2007-03-31
How do i get rid of spaces in the SQL script for the Fullname field?
The SQL is:
SELECT u.UserName as USER, u.FullName as full, u.Postcode AS pcode_orig, LEFT(u.Postcode, LENGTH(u.Postcode) - LOCATE(' ', REVERSE(u.Postcode))) as pcode, u.Tel as Tel, u.Email AS Email, u.Address AS Address, c.CustomerID FROM dict8.Customer c JOIN blabla.`User` u ON c.UserID = u.UserID WHERE u.Postcode IS NOT NULL GROUP BY pcode"