Hi All

Sorry for the late reply, first of me getting a chance to look at this particular database.

PERSONNUM is NVARCHAR(15)

I have taken away the order by clause as to be honest its not really needed as the application front end does the sorting anyway.

I have tried multiple things converting both ClockNo and 722 to numeric, converting the 722 to NVARCHAR(15) I still get the error that it cannot convert.

Regards

Douglas Bell