How to exclude data from query

[tobermory20]

Hello,

I have a statement simular to this:

SELECT     userid, last_name, first_name
FROM       organizationalPerson
WHERE     (full_name LIKE '% txtLastName %')
ORDER BY last_name, first_name

My results are vary in feedback depending on the variable txtLastName. Here is my issue, I get multiple ID's back and one person could have 5 entries. All I want to return is something like A1000 and not A1000S. How can I accomplish this goal?

Regards,
~ T

 

[tobermory20]

Found what I was looking for the answer should be:

SELECT [COLOR=red]DISTINCT SUBSTRING(userid, 1, 5)[/color], last_name, first_name 
FROM  organizationalPerson
WHERE     (full_name LIKE '% texLastName %')