Select value not in field

Posted in 1994

Anbarnes@letterkenn-emh1.army.mil — 3 Feb 1994 09:13:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Could someone help me with the SQL (NOT 4GL) syntax to select all values between x and y which are not in fieldz? For instance, fieldz contains all the numbers currently in use on tape labels. I want to see which numbers are NOT currently in use, within the available range of 0001-9999. The syntax totally escapes me! Thanks. Ann Barnes --------------------------------------------------------------------------- Ann Barnes, UNIX System Administrator \\ /\\ /\\ Letterkenny Army Depot, SDSLE-DOE \\ /\\ & \\/ \\ alumna Chambersburg, PA 17201 AV 570-9869/717-267-9869 \\/ \\/ \\ ---------------------------------------------------------------------------