When running a compare with a “where” clause when the literal string to be evaluated has a space in between, an error as seen below will occur (shown below is an example of equality comparison operator):
Compare owner.tablename ……… where NAME=‘Kevin Wong’
Error: Unknown parameter or option: Wong'
Any literal string which has space in between would need to be enclosed in single quotes when specified in the “where” clause against a field when using the comparison operator. Moreover, the complete clause after the keyword “where” needs to be enclosed in double quotes. The following illustrates the correct way to specify the condition:
Compare owner.tablename ……… where “NAME=‘Kevin Wong’”
