Hi,
I have the following SQL:
Select
a.DataID
From
(select
A1.ID as DataID
from LLAttrData A1, DTree A2
where A1.DefID = 131790
and A1.AttrID = 2
and A1.ID = A2.DataID
and A1.VerNum = A2.VersionNum
and SUBSTRING('(A1.ValStr=''test'')',1,LEN('(A1.ValStr=''test'')'))) a
I get the following error:
An expression of non-boolean type specified in a context where a condition is expected, near ')'.
I know it's because of this expression:
SUBSTRING('(A1.ValStr=''test'')',1,LEN('(A1.ValStr=''test'')'))
My problem is that this '(A1.ValStr=)' is always in qotation marks and comes from another software. Howevermy golas is it to remove the quotation marks in order to run my SQL. But it seems there is a problem with this qotations marks:
A1.ValStr=''test''
I hope you can help me?
Kind regards,
Lara