var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: replace instance of multiple char(32)
I have several fileds in a sql table which holds some text and a hell of a lot of white spaces (char(32)) which is causing some problems when I show the data on the front-end
What I want to do is use sql replace function to replace the char(32). However, because there is text I can't do a simple replace as the text will become just one word !
Can anyone tell me how to loop through the field to find the char(32), where the char(32) is greater than say 5 sapces and then replace this with just one single space
E.g. a field in a table contains the following :
"my text field and loads of spaces then some more text with loads of spaces "
I want to replace the char(32) with just one space so it looks like this :
"my text filed and loads of spaces then some more text with loads of spaces"
Thanks for your help
I'd try using:
SELECT Replace('Target string with spaces', ' ', ' ')
I had to run the replace twice...
declare @Targetstring varchar(50)
set @Targetstring = '1 2 3 4 5 6'
select Replace(@TargetString, ' ', ' ') --Not quite there yet....
select Replace(Replace(@TargetString, ' ', ' '), ' ', ' ') --Lookin' good!
Replace is kinda like that... It only makes one pass through the string on its own. It can be coerced into doing the right thing, if you have a big enough stick!