I know sql provides us with LTRIM and RTRIM but is there anyway to remove the spacing in the middle. '123 Johnson St' should be '123 Johnson St.
Anyone know of any functions or tricks?
moone009 0 Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.