You can add one more column to the table, say IsNew char(1) and populate it with 'Y' for new records and 'N' for old.

SELECT * FROM mytable
  ORDER BY IsNew, LastName

>Hi,
>
>I have a software for academic managment.
>
>This manage a list of students, like this

>Code    Last Name  First Name
>1          Montoya      Mario
>2          Zapata         Juan
>
>But, i need insert a new student for example
>
>3         Arango         Julio
>
>and in the reports, this need show it: (with ORDER BY Last Name)
>
>1          Montoya      Mario
>2          Zapata         Juan
>3         Arango         Julio

>This is a requeriment for my customers. In VFP, i put the char ALT+0216 before the last name and the database put this student in the last position.
>
>But with Sql Server 2000 this not happend. I try with all chars (0-245) but nothing work...
>
>Any idea?