excel or sql and number ordering

[davecarrera]

Hi All,

Dont know if this is a excel or sql issue so here goes

Got a excel sheet pulling data from a sql table, no prob there.

In the ms query i order my results by a field with a number in but it shows the numbe 1(one) below say number 10(ten) why would this be.

I can get around this by making my numbers start at 11 but i think when i get to say 111 its going to put that first on the ordering.

Any ideas

Dave

 

[PGoRule]

It's because, the field which you are using for order by, is ordering the result in query considering it as a text field.

Sharing the best from my side...

--Prashant--

 

[davecarrera]

thanks for the reply.

how do i go about fixing this issue ????

Kind Regards

Dave

 

[PGoRule]

What is the datatype of that field in SQL Table?
Can you post the query you are using?

Sharing the best from my side...

--Prashant--