Problem with Like statement using in query

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

General SQL Server Forums

New to SQL Server Programming

Problem with Like statement using in query

Author

Topic

joseph2078
Starting Member

1 Post

Posted - 2009-08-19 : 11:11:08

Hi All,

I am using Like statement in the query to retrieve result but the problem is when i am passing value in lower case in the query using like statement in query, it dosen't return record.

Below is the query:

Select * from System where Asset like 'gr%'

Dosen't return record But if i pass

Select * from System where Asset like 'GR%'

then i get the result.

Can you please give me any solution so i can pass value in upper or lower case and it should return result.

Thanks in Advance

Joseph

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-08-19 : 11:20:58

Select * from System where Asset like 'GR%' or Asset like 'gr%'
Select * from System where UPPER(left(Asset,2)) = 'GR'

Jim