Thought I would run something past you all
I am trying to account collect a slightly complicated application:
I am using the following SQL
Select NTUsername, Forename, Surname, EmailAddress, 'group' =
case
when permissions like '%<isSystem>true</isSystem>%' then 'LON'
else 'nogroup'
end
from User1
where IsActive=1
and NTUsername like '%ABC\%'
But Aveksa is translating it to
Select distinct
'group' =
case
when permissions like '%true%' then 'LON'
else 'nogroup'
end
from User1
where IsActive=1
and NTUsername like '%ABC\%'
Any idea how I stop MAL removing the surrounding text?
The system is most likely sanitizing the query.
Try to replace the problematic section with something like this:
_ is used as a wildcard for a single char