Re: Truncation
In article <33im3h$hv9@emory.mathcs.emory.edu> naomi@anasazi.com (Naomi Walker) writes:
>
>
>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?
update tablename set colname = colname[1,2];
Bob
--
-------------------------------------------------------------------
* Bob Beaulieu (bobb@netcom.com) eztravel@netcom.com *
* Tel: 408-978-0808 Fax: 408-978-7024 *
* Corporate Travel Services *
-------------------------------------------------------------------