I've recently started to do that as well.  Actually I have extended Microsoft Outlook's tasks list system to do this.  It works quite well.

Thanks,  I was about to post an update along those lines.  I think that I won't bother with the while loop.

That does not work because it tries to create the column and a integer type.

In relation to:

CASE WHEN ISDATE

(DischargeDate) = 1 THEN DischargeDate END,

What does the select statement return if ISDATE(DischargeDate) <> 1. ...

Sorry, I didn't look closely enough at the output.  All the '0's in the output are due to NULL values.  But the string value 'NULL' and not the <NULL>.  I really...

Sorry, I didn't look closely enough at the output.  All the '0's in the output are due to NULL values.  But the string value 'NULL' and not the <NULL>.  I really...

There are some rows that return 0s in the Expr1, Expr2, Expr3 and Expr4 columns.  Does that indicate a faulty form with some of the entires?

I am using stored procedures that are activated via a ODBC connection.  The error message is what comes through to the DOS screen when I run my Perl programs.  I...

Sorry, just updated my last post as you posted your new post.  I'm not sure whether I have detailed enough in the update.

When I try that I get the following error message:

[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. (SQL-22007)(DBD: Execute immediate failed err=-1)

This error is in the...

I don't really understand what you mean by SPECIFIC_CATALOG and SPECIFIC_SCHEMA.  I am assuming that by SPECIFIC_NAME you mean the database name.  So if I don't have different catalogs and...