Searching For Apostrophe, Asterisk, Ampersand

[TJLearn]

Hi all,

Is there a way to search for records with the following IDs?

1. ID starts by an Apostrophe
Example: 'CDE-123

2. ID are Asterisks
Example: ***

3. ID ENDS with an Ampersand
Example: 12-456&

I am using access project 2000 links to sql 7.0. I have a form and search for IDs from a combo box (drop-down box).

Your helps are greatly appreciated. Thanks!

 

[KenReay]

HI

The * may pose a problem, do not know how to do that, but the ' and the & should be found with a criteria of

Like "'*" OR LIKE "*&"

Regards

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

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

UK