Using 'LIKE' operator in SQL statement

[diamondsc]

I have tried to use the following sql statement in a VBA module:

sqlStr = "Select * From Medications Where MedName Like 'ZOCOR*';"

No records are returned. Will a Like operator not work in this situation? If not, what statement would work? Thanks.

 

[Zathras]

It depends on your DBMS. The ANSI standard wild cards are "%" for "any string of characters" and "_" for "any single character"

Try
sqlStr = "Select * From Medications Where MedName Like 'ZOCOR%';"

 

[diamondsc]

Using MS Access 2000 VBA and retrieving data from MS SQL Server 2000. I've used the like operator like this in an If statement but have never tried it in a sql statement. The asterisk is suppose to be the wild card for any string of characters.

 

[Zathras]

...[if] the prophet had bid thee [do some] great thing, wouldest thou not have done [it]? how much rather then, when he saith to thee,... (2nd Kings 5:13)

(In other words, have you tried my suggestion?)