On Fri, Jun 10, 2011 at 1:57 PM, Bill Moran <wmoran(at)potentialtech(dot)com> wrote:
> I don't think ALTER COLUMN TYPE will implicitly convert from varchar
> to INT.
>
> Try:
> ALTER TABLE reference
> ALTER COLUMN color
> TYPE INT
> USING CAST(color AS INT);
Your command suggestion worked perfect but can you explain why yours
worked and mine didn't? I've never used 'USING CAST' command before.