Hi

I have written this statement but it is not working . i have item code like diA12thd , dabd12th so on . I am using MS-Access & i have written this statement in Visual Basic 6
esql = "SELECT * FROM m_item WHERE icode like '12%'"

Openrstitem (esql)

Thanks