But you don't say what kind of database!<BR><BR>If SQL Server, it looks like it is safe to do that via<BR><BR>ALTER TABLE tablename ALTER COLUMN fieldname VARCHAR(100)<BR><BR>The docs say it's even okay to do that with a VARCHAR column when the column is indexed. <BR><BR>http://msdn.microsoft.com/library/en-us/tsqlref/ts_aa-az_3ied.asp
if you don't mind, how do I do a backup using ASP? The database is on my ISP, and they are useless when I want something done quickly.<BR><BR>Also I've been looking around for a way to be able to give the user to download all records from a table into a comma delimited file. Any pointer?<BR><BR>Thanks mate.
SELECT INTO newtable FROM oldtable<BR><BR>As I said, the TSQL docs *are* your friend.<BR><BR>http://msdn.microsoft.com/library/en-us/tsqlref/ts_sa-ses_9sfo.asp<BR><BR>That won't copy all your relationships, etc., but at least it's guaranteed to preserve your data.<BR><BR>