LIKE clause

[davetek]

Hi,
I need to match a field in a query to another field in a query using LIKE. HOwever I want to append '*' to the end of it, however i cannot seem to get the syntax correct...any suggestions:

WHERE ((([Sec_Ratios]![Security]) Like ([Sub_FUT_1]![Sec]&"*&quot));

Cheers

 

[KenReay]

Hi

Are you building this SQL string in Code? Regards

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

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

UK

 

[davetek]

well to be honest i've tried both, but the example i showed was part of an SQL string

 

[KenReay]

Hi

In that case:

"... WHERE ((([Sec_Ratios]![Security]) Like (" & [Sub_FUT_1]![Sec]& "*)));"

Regards

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

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

UK