Need a Query... [modified]

[Jamal Abdul Nasir]

--> how to determine that a data (records of two columns) exist in a table? for example:

CustomerID Customer Name City
1 John New York
2 Adam Detroit
3 Brayan Washington

--> i want to know if ("Adam" and "Detroit") exist in the same row or not....

J A Nasir K

modified on Sunday, April 12, 2009 11:45 AM

[Henry Minute]

This is such a basic operation, that I can only suggest that you do some research on T-SQL. Particularly Select and Where. Try a few things out and come back if what you try fails.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Le centriste]

use the exists statement.