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 > | Phoenix, Arizona > Everything should be made as simple | > as possible, but not simpler --Einstein | Visualize Whirled Peas > 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? ========================================================================== == George Teachman == == Soil Scientist == == United States Department of Agriculture - Soil Conservation Service == == Fort Collins, Colorado == == 303-282-1960 == == == == george@talon.ftc.scs.ag.gov == == ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ == == Welcome to earth, third rock from the sun. Cause and effect. == == There are only three laws of nature, and one exception. == == 1) F=ma; 2) E=m(c squared); 3) You can't push a rope == == From these three laws all others can be derived. == == Except those explained by CHAOS THEORY. == ==========================================================================