Sign Up ›
  • glen.duncan1.3951499282112769E12
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
2 replies

SOQL Filter by issue

Hi,

I am new to SOSQL and am having an issue with the following query where no results are returned:

SELECT i.name,
(SELECT Name FROM Line_items__r ORDER BY Name)
FROM Invoice__c i   
WHERE i.Name = 'INV-0004'

If i use a like statement then it works as expected

WHERE i.Name  like  'INV%0004'

Is it possible to use the '-' character in an equals clause in SOQL?
2 replies

SOQL Filter by issue

Hi,

I am new to SOSQL and am having an issue with the following query where no results are returned:

SELECT i.name,
(SELECT Name FROM Line_items__r ORDER BY Name)
FROM Invoice__c i   
WHERE i.Name = 'INV-0004'

If i use a like statement then it works as expected

WHERE i.Name  like  'INV%0004'

Is it possible to use the '-' character in an equals clause in SOQL?