Read/ Analyze contents of Binary columns
Hi there, For a client i want to do a detailed analysis of the data (numbers) in the database. We want to investigate the percentage of numbers < 0.01. However, when i use the Data records i see t...
Forum Discussion
MarcR wrote:In the binary table itself i see as contents of the CellAmounts the following:
When i convert this to a string i see a binary code that i cannot read.
Does anybody know how to write the select statement in SQL to see the Value fields in the CellAmounts column so i can filter on them?
Just a thought (I still don't think it is a good solution): Did you try to convert it to a decimal(28,9)?