Hi,



I have following code which work fine with MS/Acess and SQL. However when 

I use DB2 via ODBC Client Access (AS/400), "Changed" message is not 

appearing nonetheless REMARK field in some of order lines has some string 

value.



' CODE start ------------------------------------------------

if not IsEmpty(fldREMARK) then fldCheckFieldName= "changed"

'remarks = cn.execute("select count(*) from OFROMAS WHERE OrderNo 

= "&fldORDERNO&" AND (NOT REMARK IS NULL) AND REMARK<>""""").fields.item(0)

remarks = Clng(DLookUp("OFROMAS", "count(*)", "OrderNo=" & fldORDERNO& " 

and (not REMARK IS NULL) AND REMARK<>"""""))

if remarks > 0 then 

fldCheckFieldName = "<font color=""#ff0000"">changed</font>" 

else

fldCheckFieldName = "" 

end if

' CODE ends ------------------------------------------------



Can someone help to me to write REMARK<>"""" in different way so that it 

shall be understood by DB2?



Thanks in advance.



Nadeem