For example: Col A Varchar(6) contains FGHIJK
Col B char(1)
I need to insert the first character - F in this case, into Column B
I need update a column in all rows by retrieving the left-most character of Col A and insert that value into Column B
How can this be done without getting the "would be truncated" error?