thank for you advance sriwirko

Dear all Dim ProductAdapter As New OleDb.OleDbDataAdapter( _ "SELECT * FROM TCAP WHERE NTCIDCODE LIKE 'VARIABLE' ", _ sConn) ====================================================== I has a ploblem with VARIABLE String. i want to declare variable and replace than VARIABLE Exam : Public const strTest As string = "TEST" i 'm cannot declare strTest variable in sql command like that. Please help and advise me. Many thaks & best regards sriwirko