Using the expression LIKE

[Ngabay]

Hey guys,

This is probably a quick and easy question. I have a statement using the word Like, I want to be able to search by account names and I want to be able to type in a similar name and get info on that account. i.e. I type IB and I would get IBM. Here is how my statement looks, for some reason the like doesnt work. What am I doing wrong or am I searching the wrong way?


SELECT [InForce D&O Policies].*
FROM [InForce D&O Policies]
WHERE ((([InForce D&O Policies].[Account Name])LIKE[enter account name:]));

Thank you,
Nir

 

[KenReay]

Hi

SELECT [InForce D&O Policies].*
FROM [InForce D&O Policies]
WHERE ((([InForce D&O Policies].[Account Name]) LIKE [enter account name:] & "*&quot);


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Darrylles]

Ken,

For a true LIKE expression, shouldn't there also be an * prefixing the account name? e.g:
[tt]
SELECT [InForce D&O Policies].*
FROM [InForce D&O Policies]
WHERE ((([InForce D&O Policies].[Account Name]) LIKE "*" & [enter account name:] & "*&quot);
[/tt]

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[KenReay]

Hi

Depends what you want eg do you want IBM forllowed my anything, or do you want anything IBM anything

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Darrylles]

Ken,

Roger that, NG wouldn't know the distinction is all.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk