SQL Syntax

[shamas21]

Hi All

Can some tell me what im doing wrong. Im trying to bring back Any field that begin with A or B using the IN Statement.

Thanks

SELECT country, name, amount
FROM tblcountries
WHERE Name IN ('A*','B*'));

 

[WayneRyan]

shamas,

WHERE Name IN ('A*','B*'));

The items in the In clause can't contain wildcards. There is no like
operator.

Where Name Like 'A*' Or Name Like 'B*'

Also, Name is a reserved word.

hth,
Wayne

 

[WayneRyan]

shamas,

Alternatively:

WHERE Left(Name, 1) IN ('A', 'B'));

Wayne

 

[shamas21]

Many thanks Wayne

 

[MSAccessRookie]

It looks like you also have an extra ")" (see below)

WHERE Left(Name, 1) IN ('A', 'B'))

 

[WayneRyan]

Thanks Rookie,

It happens ...

Should Cut-And-Paste be illegal?

Wayne

 

[MSAccessRookie]

That would depend on what you are cutting and pasting.

Thanks Rookie,

It happens ...

Should Cut-And-Paste be illegal?

Wayne

That would depend on what you are cutting and pasting.