query result against array

Anon

///////////////I have this array/////////

AA0101

AA0202

AA0303

AA0404

AA0505

AA0606

AA0707

AA0808

AA0909

AA1010

////////////////I have this table////////

document_number id
AA0101 1
AA0202 2
AA0303 3
AA0404 4
AA0505 5
AA0606 6
AA0707 7
AA0808 8
AA0909 9
AA1010 10
AA1111 11
AA1212 12
AA1313 13
AA1414 14
AA1515 15
AA1616 16
AA1717 17
AA1818 18
AA1919 19
AA2020 20

//////////////////I want to build a query that will out put a result of all the records that are NOT LIKE the array values.

///////////Example I want the result to be:///

AA1111 11
AA1212 12
AA1313 13
AA1414 14
AA1515 15
AA1616 16
AA1717 17
AA1818 18
AA1919 19
AA2020 20

How do I do this?

Thanks

[deleted]

use implode() to create a string from the array that seperates each value with a comma.
Then use something like

SELECT * FORM table WHERE field NOT IN (1,2,3,4);

seidel

Vincent, the solution that you offered is not working with MSSQL Server 7.0 is there another way that you know or am I not using this correctly

************my query***************

$temp_links_query=mssql_query("SELECT*
FROM final_link_doc
WHERE document_number = '$document_number'
");
while($row_2=mssql_fetch_array($temp_links_query))
{

		}$link_doc_1=$row_2["link_doc_1"];
		$link_doc_2=$row_2["link_doc_2"];
		$link_doc_3=$row_2["link_doc_3"];
		$link_doc_4=$row_2["link_doc_4"];

$find_add_link_doc=mssql_query("SELECT [Document Number] FROM LINK_TEMP WHERE Field not in '$link_doc_1,$link_doc_2,$link_doc_3,$link_doc_4'
")

christopher wrote: