Double damn, so much for the "Preview" button!!

That should be two right brackets in the code.

Damn those 'faces"!!!

Try;

SELECT CONVERT (CHAR(2), left( '00', 2-len(<column name&gt ) + CONVERT(CHAR(2), <column name&gt )

FROM ....

Replace <column name>...

Try;

SELECT CONVERT (CHAR(2), left( '00', 2-len(<column name&gt) + CONVERT(CHAR(2), <column name&gt)

FROM ....

Replace <column name> with the name of...

Hi Mark,

Perhaps something along the lines of this would do the trick (you should double check it!);

select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE,

'SIZE/PRECISION'= CASE DATA_TYPE

WHEN 'char' then CHARACTER_MAXIMUM_LENGTH

WHEN 'varchar'...

Sorry, I left out the link from the previous post;

http://www.databasejournal.com/article.php/3300441

Check out the "Data partitioning in SQL Server 2005" articles by "the MAK".  One of them cover partitioning an existing table. 

Alternately check the TSQL "DROP INDEX" command "WITH MOVE"...