LIKE (Transact-SQL) - 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

SQL Server 2005 Forums

Transact-SQL (2005)

LIKE (Transact-SQL)

Author

Topic

cnaypi
Starting Member

22 Posts

Posted - 2008-05-30 : 15:28:48

I am trying to use LIKE in a statement but I can't seem to pull all the rows for Age of Empire. I have at least 50 rows with the word Age of Empire but I only get two rows. What is the best way to use LIKE in the statement below so that it pulls all rows with the words Age of Empire?

Select * from dbo.proddesc
where codeabbreviation Like '%Age of empire%'

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-30 : 15:37:51

Select * from dbo.proddesc
where codeabbreviation Like '%Age%of%empire%'

E 12°55'05.25"
N 56°04'39.16"

cnaypi
Starting Member

22 Posts

Posted - 2008-05-30 : 15:49:21

Thanks Peso :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources