Re: sorting the varchar field?

2002-02-05 Thread Diana Soares
On Tue, 2002-02-05 at 10:18, Vishakha Mali_Wagh wrote: > Now I need to sort a field of varchar type. But the filed values are like... > b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12 > meaning thereby, an integer prefixed by some character. > Is there any straight way to frame the query? OK, if the

sorting the varchar field?

2002-02-05 Thread Vishakha Mali_Wagh
hi again, Now I need to sort a field of varchar type. But the filed values are like... b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12 meaning thereby, an integer prefixed by some character. Is there any straight way to frame the query? thanx in advance for your time, regards, -vishi -