Data type: FOR BIT DATA?

[jasonswett]

Could someone please explain the concept of types being "FOR BIT DATA" to me? Here's the particular problem I'm having:

I have a SELECT statement that's something like this:
"SELECT col FROM table"
Where "col" is of type CHAR () FOR BIT DATA. If I run this query, I get some results. Let's say one of the results is "100".

If I then try to do this:
"SELECT col FROM table WHERE col='100'", it returns an empty set. What is the proper way to retrieve just this one record?

Thanks,
Jason

 

[blom0344]

In this case the data is of type binary.
So, the representation of '100' does not mean 'hundred' , but the binary notation 100.


Ties Blom