Greetings,
I'm facing a problem with the SQL Server and this problem concerning numbers when compared each other and these numbers are stored in the columns of data type NVARCHAR or VARCHAR. For example, if I'm having a column with data type NVARCHAR and it contains such values:
1
2
3
4
5
6
11
12
13
15
22
23
24
25
If I tried to get the content of the table containing this column and order the result by the content of this column it will returned the data ordered like that
1
11
12
13
15
2
22
23
24
25
3
4
5
6
which is not correct ordered
What is the solutions to problem