case-insensitive in 'like' sql statement

[admin]

How do I do a sql statement which is in case-sensitive in the 'like' sql statement?

For example, below is my sql statement, which I wish to perform in case sensitive in the search condition:

===================================
select * from TableSearch where user_id='325' AND header_subject like '%NOki%' order by header_date desc
============================

I know that 'like' in sql statement will force the search string to be case-insensitive. Any solution for this?


Thanks in advance.