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 Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Tuesday, 22 February 2005 10:34 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: IHASH Command 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. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.2.0 - Release Date: 21/02/2005
