Sql Statement

[gsc1ugs]

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.

[nialler]

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*')

[gsc1ugs]

Whcih uses SQL ASP OR C++ i'm connectiing with the ADO object?

Gary

[nialler]

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

[gsc1ugs]

yep... Access is the pain..