Ursula
08-15-2008, 08:56 AM
hello
I have a SQL report built for MSCRM and it collect the data from the external excel source. It basically display all the rows from excel where there is a match on the company name.
The current code is
select *
from [Advisors$] where
([Name of Adviser group] = ? )
order by [Deal Date] desc
How can i change it so the sciprt uses 'contains' logic rather the '='? So it brings back all the rows where the 'KPMG' for emaple is contatined in the Name rather it is exactly KPMG
Many thanks,
I have a SQL report built for MSCRM and it collect the data from the external excel source. It basically display all the rows from excel where there is a match on the company name.
The current code is
select *
from [Advisors$] where
([Name of Adviser group] = ? )
order by [Deal Date] desc
How can i change it so the sciprt uses 'contains' logic rather the '='? So it brings back all the rows where the 'KPMG' for emaple is contatined in the Name rather it is exactly KPMG
Many thanks,