Re: Truncation

} > } > A quickie for y'all.... } > } > What would be the most efficient and quickest way to truncate a } > char(6) to a char(2) in an existing table? } > } > Naomi Walker (aka N7FSA) | naomi@anasazi.com } } == George Teachman == } I'm going to assume (dangerous, very dangerous :-)) that you want } all data in the char(6) column to be char(2). My first impulse } would be to; } } alter table table_name } modify column_name char(2); } } Or, did I make an invalid assumption? If it were anyone but Naomi, I would agree. In this case she is probably more concerned with efficiency than syntax. j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| He who talks most, talks least. jparker@hpbs3645.boi.hp.com | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________