insert if not exist

[mcalpine]

how do i insert data into a table only if the data isnt in the table in the first place... using 1 sql statement...?

i've seen an "IF NOT EXIST" bit being used , but i cant get it working!!!

thanks
-m

[drawmack]

if not exist only works on create tables, you cannot do this with one sql statement. You have to first select all rows that contain your data then insert if that returns 0.

[mcalpine]

thought so....

thanks..

-m