Question and Answer Database FAQ2852D.txt — Query with a string does not work properly Category :AS400 Platform :All-32Bit Product :DelphiAS400, Question: I am doing a Query against the 400 where I specify a string, example: SELECT * FROM CUST WHERE CUSTNAME = "Sparky" But it is not working properly. What am I doing wrong? Answer: The 400 likes Single Quotes and not double quotes. You should be doing: SELECT * FROM CUST WHERE CUSTNAME = 'Sparky' 4/1/99 2:46:02 PM
Last Modified: 01-SEP-99