Hello Everyone
This may seem simple to some, but I have been sitting around here polishing up my SQL coding skills and ran into this little problem.
We all know how to remove blank space(s) from a string that are on either end. But how would you remove a blank space that is in the middle. Such as if the string is: 'New York' and you want the result to look like this: 'NewYork'
Thanks
Andrew