SQL Format

Hi Guys,

I am trying to get a selection of fields from a DB.

I can select specific records using

sql = "SELECT * FROM cds WHERE Artist = 'bryan'"
rs.open sql,cn

Not problem. But I want to able to retireve records say starting with BR.
SO when I try

sql = "SELECT * FROM cds WHERE Artist = 'br*'"
rs.open sql,cn

It just skips all files.

Please help.

I have a Access back end using Jet.

Many Thanks

Gavin.

"gavin" <##gavin@djapex.f9.co.uk##NOSPAM>'s wild thoughts
were released on Thu, 17 Feb 2005 12:59:51 GMT bearing the
following fruit:

 >Hi Guys,
 >
 >I am trying to get a selection of fields from a DB.
 >
 >I can select specific records using
 >
 >sql = "SELECT * FROM cds WHERE Artist = 'bryan'"
 >rs.open sql,cn
 >
 >Not problem. But I want to able to retireve records say starting with BR.
 >SO when I try
 >
 >sql = "SELECT * FROM cds WHERE Artist = 'br*'"
 >rs.open sql,cn
 >
 >It just skips all files.
 >
 >Please help.

SELECT * FROM cds WHERE Artist MATCHES 'br*'

SELECT * FROM cds WHERE Artist LIKE 'br%'

J


 >I have a Access back end using Jet.
 >
 >Many Thanks
 >
 >Gavin.
 >


Jan Hyde (VB MVP)

--
A man is incomplete until he is married.
After that, he is finished.

(Zsa Zsa Gabor)

[Abolish the TV Licence - <a style='text-decoration: underline;' href="http://www.tvlicensing.biz/]" target="_blank">http://www.tvlicensing.biz/]</a><!-- ~MESSAGE_AFTER~ -->