-
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.
-
The wildcard * works in access, but in SQL server it is %, for example:
Select * from Table Where (Field LIKE 'd%')
not
Select * from Table Where (Field LIKE 'd*')
-
which
Whcih uses SQL ASP OR C++ i'm connectiing with the ADO object?
Gary
-
I don't understand your last question.
When using ADO with SQL Server, always use % as the wildcard instead of *.
Does this solve your problem.
Nialler
-
yep
yep... Access is the pain..
