June 15, 2011 at 8:06 am
There's not much we can offer here. Find a way to see what line of code is not compiling (SET FMTONLY ON might help).
Once you see that correct it and be on your way.
June 15, 2011 at 11:12 am
Not sure what you mean by not working but I suspect it is not producing the desired results? The replace statement is probably not doing what you think/expect.
Select Col1, Replace(Col2,' ',' ') From Table
You are replacing all single spaces with single spaces. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply