Jonathan,

PERFACT.....

Thanx

because both the pol#'s(112-124-05) are same... I'm looking for those values where pol#'s are different for same trck#.

trck#, pol#

B-001-111, 112-124-05

B-001-111, 112-124-05

I need to pull those records from a table X where pol#'s are different for single trck#.

Single trck#(A-001-111) has multiple pol#'s(123-123-01/03/04/05).

pol# and trck# are two columns

trck# = A-001-111

pol# =...