Select by Attributes fails to execute in ArcMap 10, when using a long expression, with the following error message, "General function failure, Query too complex ".
Remove the spaces from the field using LTrim and RTrim commands. Reformat the query to select multiple values from the same Field, [FieldName] IN ('4189', '4190', '4191').