I have a need to remove white spaces from a field that can be zero length. When I use the REPLACE function I get an error on the zero length fields. I know I could update the fields first with a value but I am sure there is an easier way. Any help would be appreaciated ...
SELECT Replace([Street1]," ","",1) AS Street1N
I can do something as follows but would like to be able to do it with a function (unsuccessful with an Iff stmt)
SELECT Replace(Street1)," ","",1) AS Street1N, Street2, City, Zip
WHERE Street1 IS NOT NULL
SELECT Street1 AS Street1N, Street2, City, Zip
WHERE Street1 IS NULL
Last edited by vegas1974; 05-05-04 at 23:28.
Reason: Added more content