I have been using MySQL on and off for a number of years but I am
stumped by this problem.
I am doing a select which requires a join to a second table using an
account key, I have a WHERE clause which ensures that I only get the
correct type of account.
Basically the type of account is 'CUSTOMER' but if I use the code
....
WHERE ACCOUNT.TYPE="CUSTOMER"
....
Then I get no matches.
However, if I use
....
WHERE STRCMP(ACCOUNT.TYPE,"CUSTOMER")=0
....
Then I get matches as expected.
Could anyone explain why I get a result set with a STRCMP match, but
not with the equals operator?
TIA
