February 26, 2015 at 4:38 pm
So I have a text such as this 'D N C Parks & Resorts @ Ksc'
Where I need to remove the spaces between DNC and Parks & Reck. So that the final outcome should look like this: 'DNC Parks&Resorts @ Ksc.
Is there a code to do this. Please help
February 26, 2015 at 11:37 pm
Simply replace ' & ' with '&'
😎
February 27, 2015 at 6:31 am
Replacing just some of the spaces and not other spaces with no precise set of rules means the Mark I eyeball is going to have to be used to do this. IF you have a clear logical mechanism for defining which spaces to remove, here is where the string manipulation functions are.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply