Posted by pinney.colton@gmail.com on 04/01/07 11:59

On Apr 1, 5:00 am, Erland Sommarskog <esq...@sommarskog.se> wrote:

> SELECT varcharcol, COUNT(*) FROM tbl GROUP BY varcharcol
>
> should give you an indication of what really is in that column. Say that you
> find something like:
>
> 0 1234
> 1 9802
> Y 23
> N 12
> X 1

I see the approach you're taking. I should have been more clear in my
original post - it's not just bool's that I have issues with - it's
every data type. Data that should be stored as an int (or tinyint) is
stored as a varchar, data that should be stored as a datetime is
stored as a varchar, data that should be stored as a float is stored
as a varchar. I'm looking to convert all of that data. Bool data was
just an example.

I'll work with this suggestion and see how far I can get.

[Back to original message]