Nallya (5/5/2016)
Its for single record I have 10 million records in table.and space betwwen two values is not fixed .
somewhre its 3 to 10
please see this article that shows how to remove multiple spaces
http://www.sqlservercentral.com/articles/T-SQL/68378/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day