I am trying to select a particular record from a table and for some reason it only returns 1 record when I know there are at least 6. I've tried Rtrim and left to make sure that I'm getting the exact string. The "MyID" field is varchar(32) and the "ExpireDate field is datetime and I have tried the below. Any ideas what could be wrong?
Select DISTINCT K.MyID, KP.[EXPIREDATE] --, K.ACTIVATIONKEY
From [KEY] K INNER JOIN KEY_PRODUCT KP
ON K.MyKey = KP.MyKey
Where K.MyID = '013BEB73C2CF11D39F3600105A05264C'