I Have a query result,getFilePackageAudit. This query result has 3 columns FilemasterID, TrackNo, and CodeNo.

getFilePackageAudit result is as below:

FilemasterID  TrackNO CodeNo
1234           345     231
78964          111     2346

I need to check for particular values that exist in the query result. i.e., For Example, I need to check if FIlemasterID = 1234 exists in the getFilePackageAudit result.

Is there any ColdFusion function that exists for this?