Sum of different values on the same row in a table I have a table with numbers from 0-5, under different field names (Score1, Score2 etc. all the way to Score50) that need to be summed at the last column of that same row. Each row represents a different client with its own info. 

Is it possible and if it is, some help would be nice.
select *, Score1 + Score2 + ... + Score50 as TotalScore
from table


You can fill in the rest of the scores :-)

By the way, you really should normalise this table. It will make your life much easier.