Hello.
I am trying to use a wildcard in a case statement, but, can't seem to get my head around it.
Select
cct.FinancialAccountNumber,
cct.Amount,
cct.PostedDate,
Match = Case When cct.SystemSequencxeNumber Like (Select ah.TokenString From AccountHistory ah Where cct.MemberNumber = ah.MemberNumber and cct.LoanNumber = ah.AccountNumber) Then 'X' Else '' End
From
CreditCardTransaction cct
Where
cct.PostedDate Between '04/01/2022' AND '04/30/2022'
Basically I'm trying match if anything in ah.TokenString = cct.SystemSequenceNumber
Is that possible? Thanks.