Brian

Here is another script to list all columns that have a "char" datatype where they possibly should be "varchar".

select sysobjects.name, sysusers.name, syscolumns.name

from syscolumns, sysobjects, sysusers

where syscolumns.type = 47

and syscolumns.id = sysobjects.id

and sysobjects.uid = sysusers.uid

and sysobjects.xtype = 'U'

order by 2,1