Thank you for your responses. I will use an order by.

Which version of BOL do you have?

Mine (SQL2K) only shows:

ORDER BY Clause

Specifies the sort for the...

where convert(varchar(10), date_column, 101) = convert(varchar(10), getdate()-1, 101)

Most developers would use a stored procedure that your application would call to generate the next number.

Since I'm more of a DBA than a developer, I would use an...

Try this:

select cast(convert(varchar(10),[field_name],101) as smalldatetime)

The following is probably what you want. I joined the inserted table and changed the where clause to use the inserted table. I'm also assuming that sch_id is a primary...

It looks like you're trying to get a list of sysobjects for every database. If so, copy and paste the following in Query Analyzer:

sp_MSforeachdb 'select substring(name, 1, 30) ''[?]'' from...