Unsorted list of result

>> I had comment the "order by" command but I obtain a sorted list result ... why?

Without Order By clause result would be based on Clustered index if you have any or else it is inrandom manner

>> I'd like an unsorted list.. The my order must be this

Use below as ORDER BY clause and try:

order by (case       when TSName = 'Rated power' then 1 
                                        when TSName = 'Amperage at voltage 230 V' then 2
                                        when TSName = 'Battery capacity' then 3
                                        when TSName = 'No-load speed' then 2
                                        when TSName = 'Max. Ø of rubber plate' then 3
                          end) asc

---

-Vaibhav Chaudhari

Thanks this work fine..