Problems with LIKE in SQL

[VB Programmer]

Using ASPX page with Access db.

When I run a query in Access it returns many records. When I run it via
ADO.NET it returns 0.

It uses a LIKE statement in the WHERE clause. Here's the statement:
SELECT [Employees].[LastName] & ', ' & [Employees].[FirstName] AS AreaMgr,
Stores.StoreName AS StoreName, Stores.StoreId AS StoreId,
Stores.NumberQCRequired AS NumberQCRequired, Plan.PlanDate AS PlanDate,
Employees.RegionalDirectorId, Stores.StoreTypeId FROM (Employees INNER JOIN
Stores ON Employees.EmployeeId = Stores.AreaManager) LEFT JOIN Plan ON
Stores.StoreId = Plan.StoreId WHERE ((Plan.PlanDate >= #9/1/2004# AND
Plan.PlanDate < #10/1/2004#) Or (Plan.PlanDate Is Null)) AND
(Stores.StoreName LIKE 'Home*') ORDER BY Stores.StoreName, Plan.PlanDate;

Any ideas?

Thanks!

 

[VB Programmer]

Thanks.

What is the symbol for only 1 character?

Change the '*' to '%'

Using ASPX page with Access db.

When I run a query in Access it returns many records. When I run it via
ADO.NET it returns 0.

It uses a LIKE statement in the WHERE clause. Here's the statement:
SELECT [Employees].[LastName] & ', ' & [Employees].[FirstName] AS AreaMgr,
Stores.StoreName AS StoreName, Stores.StoreId AS StoreId,
Stores.NumberQCRequired AS NumberQCRequired, Plan.PlanDate AS PlanDate,
Employees.RegionalDirectorId, Stores.StoreTypeId FROM (Employees INNER JOIN
Stores ON Employees.EmployeeId = Stores.AreaManager) LEFT JOIN Plan ON
Stores.StoreId = Plan.StoreId WHERE ((Plan.PlanDate >= #9/1/2004# AND
Plan.PlanDate < #10/1/2004#) Or (Plan.PlanDate Is Null)) AND
(Stores.StoreName LIKE 'Home*') ORDER BY Stores.StoreName, Plan.PlanDate;

Any ideas?

Thanks!

 

[VB Programmer]

I found it: _

Thanks.

What is the symbol for only 1 character?

Change the '*' to '%'

Using ASPX page with Access db.

When I run a query in Access it returns many records. When I run it via
ADO.NET it returns 0.

It uses a LIKE statement in the WHERE clause. Here's the statement:
SELECT [Employees].[LastName] & ', ' & [Employees].[FirstName] AS AreaMgr,
Stores.StoreName AS StoreName, Stores.StoreId AS StoreId,
Stores.NumberQCRequired AS NumberQCRequired, Plan.PlanDate AS PlanDate,
Employees.RegionalDirectorId, Stores.StoreTypeId FROM (Employees INNER JOIN
Stores ON Employees.EmployeeId = Stores.AreaManager) LEFT JOIN Plan ON
Stores.StoreId = Plan.StoreId WHERE ((Plan.PlanDate >= #9/1/2004# AND
Plan.PlanDate < #10/1/2004#) Or (Plan.PlanDate Is Null)) AND
(Stores.StoreName LIKE 'Home*') ORDER BY Stores.StoreName, Plan.PlanDate;

Any ideas?

Thanks!