Apex Code Development You need to sign in to do that
Don't have an account?
Jaanek empty resultset when selecting a contact with LastName='?'
Good morning.
We've a contact associated with account with LastName='?' (a questionmark as value) and FirstName='Test' . When i do a select like this: select Id,FirstName,LastName from Contact where LastName='?' i get an empty resultset back. It's the same when LastName has a period as a value. When i change the LastName value to something else i get back that record correctly. Is there something i miss here.
thank you,
/Jaanek
We've a contact associated with account with LastName='?' (a questionmark as value) and FirstName='Test' . When i do a select like this: select Id,FirstName,LastName from Contact where LastName='?' i get an empty resultset back. It's the same when LastName has a period as a value. When i change the LastName value to something else i get back that record correctly. Is there something i miss here.
thank you,
/Jaanek
the charracter you mention as is ? and . are special character
try your query with where LastName='\?' and it should work
Regards