major issues in a data conversion project - any help is much appreciated... app - connection via DSN Client Access ODBC Driver to i-series.

when I execute select SQL statement via app, no WHERE clause, or WHERE clause on numeric field statement executes fine.

however, WHERE field = 'value' for a char field, error returned is 42s22. it appears to ID 'value' as a field name in the same table rather than an actual value...

the messed up thing here is that yesterday this worked fine???

the ODBC trace tool on the server side sees these single quotes which leads me to believe its not a format conversion (CCSID - whatever the thats all about) issue.

thanks very much