Stumped with LIKE query
- From: "sonicsix" <u35639@uwe>
- Date: Fri, 06 Jul 2007 19:21:17 GMT
I have a MS Access database (from Office XP) to catalog my movies in. Here's
my dilemma... I have Shrek 1 an 2. From within Access, how can I query the
names so Shrek and Shrek 2 are both returned? I either get one or nothing.
Here's what I have tried (among other things):
SELECT Table1.MovieName, Table1.MovieYear, Table1.Category, Table1.Rating,
Table1.Plot
FROM Table1
WHERE Table1.MovieName Like [Enter Movie Name];
That returns only "Shrek" and not "Shrek 2".
------------------------------------------------------------------------------
-----
SELECT Table1.MovieName, Table1.MovieYear, Table1.Category, Table1.Rating,
Table1.Plot
FROM Table1
WHERE Table1.MovieName Like "%[Enter Movie Name]%";
That returns nothing as it doesn't rpompt me for a partial title name. Any
help?
Thank you very much.
.
- Follow-Ups:
- Re: Stumped with LIKE query
- From: John Spencer
- Re: Stumped with LIKE query
- Prev by Date: Re: SQL Syntax Error
- Next by Date: Re: Stumped with LIKE query
- Previous by thread: RE: Returning too many lines
- Next by thread: Re: Stumped with LIKE query
- Index(es):
Relevant Pages
|
Loading
