SQL Vs PB

[docky5]

HI

My problem is, I select a bacnh of info from an SQL server into a datawindow and I wanted to sort them by name BUT there is a difference between the order of alphabetic order in SQL and PB. In SQL the '-' sign comes before chars but in PB it is coming after the characters.

How can I have the same order in PB as in SQL?

Thanks the help in advance.

 

[nsantin]

If you only need to sort once, then try to remove the sort on the DW and add an ORDER BY to the SQL source. This way the DW will load presorted the way you want.