strsql="select * from life_pds where big='%"&search&"%' or big_category='%"&searchstring&"%' or mid_category='%"&searchstring&"%' or filename='%"&searchstring&"%' or content like '%"&searchstring&"%' order by pk_id desc"

select 구문을 이렇게 처리했는데..

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Informix][Informix ODBC Driver][Informix]Wildcard matching may not be used with non-character types.

/sm_pds_search.asp, line 69

이런 오류가 나네요.. 위의 select는 mssql문을 그대로.인포믹스서버에...

올린 예입니다..

빠른 답변부탁합니다.