Sort my data with a specific order

[Fanch]

Hi evrybody,

I want to migrate an SQL script that is run by VB program on QlikView.

In my result by VB Program, the data are sorted like this 🙂 : 

- Umyitem

- Webmyitem

- Zamyitem

- Z@myitem

- Z-myitem

When i run by QlikView, the date are sorted like this 🙄 : 

- Umyitem

- Webmyitem

- Z-myitem

- Z@myitem

- Zamyitem

How can i proceed to have the same data with the same order ? I've tried on the sheet Sort on my table Box Properties and i've never change the script SQL

Thanks a lot for your answers 🙂