0

attached is a screenshot of what my table already has for the URL micorosft.com.
The column headings are the same as column names. Now, if I do the following statement:

select * from assign2 where UPPER(keyword1) LIKE '%MICROSOFT%';

OR

select * from assign2 where keyword1 LIKE '%microsoft%';

I am being returned an empty set.
Any suggestions?

Attachments sql.jpg 77.52 KB
2
Contributors
5
Replies
6
Views
8 Years
Discussion Span
Last Post by sid78669
0

also try this statement also

select * FROM assign2 WHERE UPPER(CONVERT(keyword1 USING latin1)) LIKE '%MICROSOFT%';
0

Yes, the select statment worked! Could you please tell me why Convert and using latin1 were required?

0

The select statement provided with me with the same data set that I had attached as an image. Thanks alot for helping!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.