try this

select sysobjects.name as TableName ,syscolumns.name as ColumnName ,systypes.name as TypeData from

sysobjects inner join

syscolumns  on sysobjects.id = syscolumns.id        inner join

systypes    on syscolumns.xtype = systypes.xtype

where sysobjects.name = 'your table'

If your data in a column in table try this :

update [Name of Table] set name [Name of Column] = REPLACE ( [Name of Column] ,'...

Mr Steve

I've tried this script on database with size about 1.5 GB , and it took about 14 minutes.