The following code is an example of how to find a list of all person records that have the firstname of 'Jim' (probably not the best way, but this is just an example of this method).
SELECT
PersonId
FROM
Person
WHERE
'Jim' IN (SELECT FirstName FROM Person)
