You could parse the string and store the 4 integers in 4 INT columns, and use them to sort. Create a computed column that returns the 4 integers together...

Use msdb..sp_help_job

JohnG,

Just for clarification, are you saying that a date/time value 1 millisecond before midnight and a date/time value 1 millisecond after midnight would have the same value in a "datetime"...

We've put our data (not logs) on raid 10 (1+0, actually). It's better performance than raid 5, although it certainly costs more. However, disks these days are cheap...

Here is sample VB code to display all available SQL servers:

    Dim i As Integer

    For i = 1 To SQLDMO.ListAvailableSQLServers.Count

        MsgBox SQLDMO.ListAvailableSQLServers(i)

    Next i

Have you tried SQL-DMO?  What is your development environment?

Try the following.  It will do what you want for every stored procedure in the current database.  You will have to have Update permission on the syscomments table.

update sys.syscomments

  set...