creating a table of pairs of record IDs for records with similar content in text field 
Author Message
 creating a table of pairs of record IDs for records with similar content in text field
I am trying to create a SQL query that will create a new table storing in
two fields pairs of record identity columns of records that have certain
amounts of word in common in a text field.
Any ideas??

Table 1:
ID - identity
TextField - description of product

New Table:
ID1
ID2
# of Words in common (ideally)

--
Philip H Horvath
Academic Technology Development

Tel 773.325.4539
Fax 773.325.7167



Sun, 02 Jun 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. creating table with pairs of similar records out of other table

2. creating pairs of similar records

3. Get record ID of a new record created with INSERT

4. pass id and find a value that is similar to that record

5. How can I retrieve the latest record in a list of similar records

6. dBase IV: counting similar records in non-numeric fields

7. How to force ADO to lock current record, without changing record's contents

8. polling difference between similar records within a table

9. How to extract the difference data records from two similar tables

10. Error 0x80040E21 adding record containing text field to empty table

11. selecting items in a Data bound list and passing a field content for the selected record

12. Copying a record in a field to several records in same field


 
Powered by phpBB® Forum Software