I'm having problems using a wildcard in ADO, i do the following, any help welcome...

str.printf("Select STD, provincebid From PROVINCEB_IDENTIFY where STD like '%s*';",szTempTelCode);
rs2 = m_db->Execute(mlExecReadWrite,str);

szTempTelCode is number a like 20300, i then chop a character off each time in a while loop until for instance 203*. there are instances at theis poit but are not detected..


Gary

PS: This line however works direct in Access.