How do I do an extended SQL search with "where" from VB5

[dave jones]

Currently I have [Set rN2 = dbs2.OpenRecord set("SELECT chn_lg_pk, chn_lg_table_na me, chn_lg_pk_value , chn_lg_field_na me, chn_lg_new_valu e, chn_lg_is_delet e, chn_lg_usr_fk, chn_lg_date_tim e , chn_lg_dmn_fk , chn_lg_bt_versi on From cw_change_log WHERE (UCASE(chn_lg_n ew_value) = 'zzz1234')")\]

where zzz1234 is the encoded id number. If I take the "where" clause off, I get results. If I use the "where" clause, I receive an error>>"ODBC--call failed"

[dave jones]

Also, this queery is copied from the enterprise manager where it works. I'm trying to automate a couple of things thru VB

[dave jones]

I also tried

[Set rN2 = dbs2.OpenRecord set("SELECT chn_lg_pk, chn_lg_table_na me, chn_lg_pk_value , chn_lg_field_na me, chn_lg_new_valu e, chn_lg_is_delet e, chn_lg_usr_fk, chn_lg_date_tim e , chn_lg_dmn_fk , chn_lg_bt_versi on From cw_change_log WHERE (chn_lg_new_val ue LIKE 'zzz1234')")]