At 04:51 PM 2/21/2005, John Docherty wrote:
Razzak,
Data from my new table, qt is as follows - I added the two 'problem' rows, which I have since found are not unique in my data, as follows.
R>sel company nvhash from qt company nvhash ---------------------------------------- ---------- 250Computer Warehouse - II 507350364 350Microtech University 935204673 450Industrial Computers Inc. 524758399 550Computer Mountain Inc. 333077815 250spirosetplaininsulated 963864368 350spirosetplaininsulated 963864368
John,
The reason you have the SAME IHASH value for the last two records is that both "TEXT" values (strings) are exactly the same.
FYI, the IHASH function is designed to create effective integer keys from the text columns.
The function, IHASH, converts the entire TEXT value, or just a specified number of TEXT characters.
Hope that explains!
Very Best R:egards,
Razzak.
