Am I right in assuming you want to move all columns to the left as far as possible where the target column is not null?
If so you will want to run an update statement using coalesce.
How far have you got? we might be able to tweak the code you have already tried
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx