lulu50
asked on
Help Remove empty space
Hi,
Is there a way to remove any empty space in my ChurchTbl.ChurchName field.
My javascript is not working correct because of empty spaces at the end of the churchName.
some record don't have any empty spaces and some do have.
I need to check for an empty spaces and remove it .
Thanks,
Is there a way to remove any empty space in my ChurchTbl.ChurchName field.
My javascript is not working correct because of empty spaces at the end of the churchName.
some record don't have any empty spaces and some do have.
I need to check for an empty spaces and remove it .
Thanks,
SELECT CityTbl.CityID, ChurchTbl.ChurchID, ChurchTbl.ChurchName
FROM StateTbl
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help
ASKER