I'm curious if there's a way, with SQL2k, to look at a binary/varbinary field and return a record based on its content - i.e. if a certain position within the value is 1 or 0.
Say I've got a value, 11. That's got 1,2,and 8 in it - basically, 1101. Say I've got another, 9 - that's got 1 and 8 in it, or 1001. I'd like to be able to restrict a query by getting all records that have the '2' position present in the binary value stored in the field - in the case above, the record that has '11' in it would return, and the record with '9' would not. Is there a way to do this with SQL2k? Or, is there a BETTER method of tackling something like this? ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
