Dear Friends,

Thank U so much for u'r replies.

Everyone of u'r replies where very informative.I could solve the problem by the logic given by "Frank Kalis".Thanks for that.

I just couldn't believe...

Dear Steve,

Just check the strings.

It should be coming in the following order.

RKA10

RKA11

RKA100

RMX10

RMX11

RMX100

RSA12

RSA120

RSA139

RSBH01

But what i get is in the following order after ordering.

RKA10

RKA100

RKA11

RMX10

RMX100

RMX11

RSA139

RSA12

RSA120

RSBH01

regards...

Dear Friends,

Sorry for the incomplete question.

It should be sorted according to the ascii ordering and the RDBMS is SQL SERVER.

                               regards

                                        shown_sunny

           ...