Teaching myself SQL and really stuck on query syntex

[viki]

trying to query farmers list database, with a field with individual farmers numbers and want the query to just be farmers numbers beginning with
different letters of the alphabet, eg A. Keep getting error 3075 eg


SELECT *
FROM [Farmers List].[Farmers No]
WHERE [Farmers List].[Farmers No] LIKE "A*";

this gives me error 3075. I have tried

[Farmers List].[Farmers No] LIKE 'A%'

which returns no records at all. Would really love some help here.

Many thanks Viki

[CaptainD]

trying to query farmers list database, with a field with individual farmers numbers and want the query to just be farmers numbers beginning with
different letters of the alphabet, eg A. Keep getting error 3075 eg


SELECT *
FROM [Farmers List].[Farmers No]
WHERE [Farmers List].[Farmers No] LIKE "A*";

this gives me error 3075. I have tried

[Farmers List].[Farmers No] LIKE 'A%'

which returns no records at all. Would really love some help here.

Many thanks Viki

Try

SELECT [Farmers No] FROM [Farmers List] WHERE [Farmers No] LIKE "A*"

[viki]

Try

SELECT [Farmers No] FROM [Farmers List] WHERE [Farmers No] LIKE "A*"

Many thanks.. its working now