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
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