It gives the initials but it doesnt sort them in ascending order .

Anyway Thanks for the reply !

Thanx a ton Kenneth !

Hi Hari,

Pkt_type is fixed from 0 to 5

whereas pkt_id can be anything but in real time it will be from 1 to say max. 50...

Ok Bye.....

Thanx Jasper once again i am relieved......

Also i have one more query ..

I have an f_name column in one table . I have to match this column against f_name ,m_name,l_name....

Jesper,

Its amazing....... it took me 40 secs to process 1 million records.

Thanx a ton !!!!

Rajesh

No both the strings are of 36 each.....

No both the strings are of 36 each.....

Hi Jesper,

Thanx a lot !!!!!

Iam getting the right results...i will just chek on 4 million records and see the timings....

Thanx again,

Rajesh

Thanx Kenneth...

Acually there are approximately 4 million records ..therefore one has to run the loop 36 * 4 million times....so its taking a lot of time...

Nevertheless thanks for ur reply....

Rgds,

Rajesh