Posted by Verticon:: on 05/17/06 21:14

I have a situation where I need a table if bad items to match to. For
example, The main table may be as:

Table Main:
fd_Id INT IDENTITY (1, 1)
fd_Type VARCHAR(100)

Table Matcher:
fd_SubType VARCHAR(20)

Table Main might have a records like:
1 | "This is some full amount of text"
2 | "Here is half amount of text"
3 | "Some more with a catch word"

Table Matcher:
"full"
"catch"

I need to only get the records from the main table that do not have
anything in the match table. This should return only record 2.

• Next in forum: Re: Problem with Delete On Linked Server
• Prev in forum: Convert Access Query to SQL Server View
• Thread view: Retrieve good records from a bad record table

[Reply to this message]