Gary Nobles wrote: > the next problem I have is that v.db.join takes the table > but changes varchar(10) to char(1) and so truncates the records! > > How do I get round this? > > I'm using MySQL what does "db.describe -c" say about the table? Hamish