ordering values in a cell

Data
10 13 15 3 26
10 13 20 35 29
10 13 5 26 2
10 15 27 34 33

Query
Declare @num1 char(5)
Set @num1 = (SELECT ltrim(Substring(ltrim(number2), 8, CHARINDEX(' ', ltrim(number2)))) FROM Num2played)
SELECT @num1 FROM Num2played

Error
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Any suggestions or fix?

Thank you.
=========================================
The data above is in one colum. I would like to rearange the
numbers in order. e.g. from "10 13 15 3 26" to "3 10 13 15 26".

Try

Set @num1 IN (SELECT

rather than

Set @num1 = (SELECT

What are you trying to do?




That's not valid T-SQL.

The data above is in one colum. I would like to rearange the
numbers in order. e.g. from "10 13 15 3 26" to "3 10 13 15 26". I can get the each unique value, but I don't know how to compare it. If that make sense. This is why I am trying to assign each unique value to a variable and then compare the variables from smallest to the largest.

I am doing the query piece by piece.

It is true, the sql above it bad.

You shouldn't store multiple values in one column. Store each value separately after which it is no problem to get the data in a specific order.