By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

Data type: FOR BIT DATA?

P: 2
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
Mar 28 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.