SQL string sensitive search

declare @reason varchar(4000)

set @reason = 'Test, Reason'

select *
from Transactions t
where t.UserReason in (select item from dbo.CreateStringTable(@reason))

Select allOpen in new window

I have a stored procedure which accepts @reason as an incoming string parameter, but for the purposes of this post, I declred @reason manually, and assigned it some test values. In the stored procedure, we use a function "CreateStringTable", which accepts a string of comma separated values, and returns them as a column in a table.

To avoid confusion, the query above can be seen as:

select *
from Transactions t
where t.UserReason in (select columnA from TableA)

Select allOpen in new window

How do I do a case-sensitive search of this? In other words, if columnA only contains the word 'Test', and t.UserReason contains only the word 'test', no records should be returned.