Query results in ComboBox

[FATE]

I have such problem : my query works right, but in ComboBox I got results with wrong sort.
Query results is:
Street 8
Street 8a
Street 10
Street 10/12

But in ComboBox data views such:
Street 10/12
Street 10
Street 8a
Street 8

Please help me!

 

[DALeffler]

Does your query have an ORDER BY clause? If so, could you pst the SQL?

 

[FATE]

Yes, ORDER BY CLAUSE. Here is my query:

SELECT TOP 100 PERCENT m.monument_id, ISNULL(d .name + ', ', '')
+ ISNULL(c.name + ', ', '') + ISNULL(b.name + ', ', '')
+ ISNULL(a.name, '') + ISNULL
((SELECT isnull(', ' + b.street_name, '')
+ isnull(' ' + ltrim(g.nr_num), '')
+ isnull('/' + ltrim(g.nr_num2), '') + isnull(g.nr_char2, '')
+ isnull(', k- ' + g.nr_char, '') + isnull(', dz- ' + g.nr_dz, '')
AS Expr1
FROM VK_Street_names b INNER JOIN
VK_Streets c ON
c.street_name_id = b.street_name_id
WHERE (c.street_id = g.street_id)), '')
+ ISNULL(', māj: ' + g.home_name, '') AS Expr1
FROM VK_Xref_Adr_Mon m INNER JOIN
VK_Address g ON g.address_id = m.address_id INNER JOIN
VK_Territories a ON g.atvk_id = a.atvk_id LEFT OUTER JOIN
VK_Territories b ON
a.ref_atvk_id = b.atvk_id LEFT OUTER JOIN
VK_Territories c ON
b.ref_atvk_id = c.atvk_id LEFT OUTER JOIN
VK_Territories d ON c.ref_atvk_id = d .atvk_id
ORDER BY ISNULL(d .name + ', ', '') + ISNULL(c.name + ', ', '')
+ ISNULL(b.name + ', ', '') + ISNULL(a.name, '') + ISNULL
((SELECT (b.street_name) AS Expr1
FROM VK_Street_names b INNER JOIN
VK_Streets c ON
c.street_name_id = b.street_name_id
WHERE (c.street_id = g.street_id)), '') + ISNULL(g.home_name,
''), g.nr_num, g.nr_num2, g.nr_char2, g.nr_char, g.nr_dz