Help on SQL Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Help on SQL Query

Author

Topic

Darkstone
Starting Member

1 Post

Posted - 2010-03-31 : 14:22:19

Hi,

I have a query that goes like this

SELECT *
FROM Library
WHERE title LIKE '%The%';

And when I run it, it doesn't return any rows from the table.
There are rows which it should return, and I am 90% sure that the syntax goes like that, and still it doesn't work.

Any help?

PackRat
Starting Member

26 Posts

Posted - 2010-03-31 : 14:36:25

I may be a little fuzzy on access sql, but I think you need to use * as the wildcard rather than %

SELECT *
FROM Library
WHERE title LIKE '*The*';

_____________________________
wrote this on my TRS-80 COCO4

<PakRat/>

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2010-04-06 : 05:29:40

have you case-sensitive data? maybe "The" should be "the"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources