sql = "update [note] " & _ " set flag='on' " & _ " where doc_type='credit' " & _ " and doc_type='debit' and doc_no like " & "'" & text1 & "%'"
DOC_NO DOC_TYPE RETURN FLAG 121001 DEBIT off //on 666 CREDIT 121002 off //on 122004 DC off 888 CREDIT 121005 off //on 122006 DC off
UPDATE [note] set flag="on" WHERE doc_type="credit"
UPDATE [note] set flag="on" WHERE doc_no like "121*"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)