Editing SQL

If you manually type the logical keyword (such as "and") to the value in the SQL Select painter, the model conversion and data retrieval in PowerServer will have the error: Incorrect syntax near ')'. To resolve this error, you will need to select the logical operator (such as "and"), instead of manually typing it. Or go to the Source Editor, and change AND~" to ~" LOGIC = ~"and~".