Is there any escape charater for "@" in Table look up.
I have string in the where condition which has a @ character in it and the table loop up tries to find a attribute
Thanks in advance
Unfortunately this is a limitation in AF versions through AF 2.5. AF will treat any @ as an attribute reference in a Table Lookup WHERE clause. The workaround is to create an Attribute with the string value you want to compare and reference that attribute in your Table Lookup WHERE clause. We expect to remove this limitation in AF 2.6.
Has this been 'resolved' in AF 2.6? If so what is the escape character.
@ is a string character, so like any other character in SQL it should work if you put it in single quotes in a WHERE clause:
SELECT bigint FROM TwoTimes WHERE nchar10 <> '@'
Retrieving data ...