At 02:07 PM 2/21/2005, John Docherty wrote:
I have a computed column (deh) using the IHASH function (on column de5)
which I thought would convert different strings to different hash values.
I have found a problem where the strings are different, (first character
only in this case) but the hash values are the same.
John,
01. Create a quick table (QuickTest) with the following columns:
1 Company Type : TEXT 40
2 NewValueAsIHASH Type : INTEGER
Compute: (IHASH(Company,0))
02. Add the following data for the Company column (four rows)
250Computer Warehouse
350Microtech University
450Industrial Computers Inc.
550Computer Mountain Inc.
03. At the R> Prompt:
SELECT * FROM QuickTest
Company NewValueAsIHASH
----------------------------------- ---------------
250Computer Warehouse - II 507350364
350Microtech University 935204673
450Industrial Computers Inc. 524758399
550Computer Mountain Inc. 333077815
What results do you get?
Very Best R:egards,
Razzak.
