Is there a way to remove any empty space in my ChurchTbl.ChurchName field.
some record don't have any empty spaces and some do have.
I need to check for an empty spaces and remove it .
SELECT CityTbl.CityID, ChurchTbl.ChurchID, ChurchTbl.ChurchName
LEFT JOIN CityTbl ON CityTbl.StateID = StateTbl.StateID
LEFT JOIN ChurchTbl ON ChurchTbl.ChCityID = CityTbl.CityID
WHERE ChurchTbl.ChurchName <> "null" and ChurchTbl.ChurchStatus = 1
and CityTbl.CityStatus = 1 and StateTbl.StateStatus = 1
and ChurchTbl.ChurchID >= 13773
order by ChurchTbl.ChurchName ASC