AND VOTERS NOT LIKE '%" - what does this mean?

[NeilBelgium]

i have a questionnaire application, which someone helped me to develop.
i need to amend so that the person can vote for themselves.
i think this may mean that if the username is the same as the person selected to vote for, then no can do.

the whole line reads:
rsListing.Source = "SELECT U_FIRST + ' ' + U_LAST AS NAME, MGR_DIR FROM HAVE_VOTED, USERS WHERE MGR_DIR = U_ID AND VOTERS NOT LIKE '%" + Replace(rsListing__varUser, "'", "''&quot + "%'"

am I correct?
thanks, neil

 

[goatstudio]

What is the VOTERS mean? Is it kind like user id or something, I suggest compare with the user id, "LIKE %" statement will cause some of other record may selected also. ------------------
Freedom is a Right

 

[imstillatwork]

Or are you confused with the SQL:
'%"+Replace(rsListing__varUser,"'","''&quot+"%'
the '%" "%' will search for 'like' records, not exact matches:
"+Replace(rsListing__varUser,"'","''&quot+"