I'm need to create a custom string to use with an IN clause so I can create a query like the following.
SELECT
*
FROM
dbo.Cassette C
INNER JOIN
dbo.ProductVersion PV ON C.ProductVersionID = PV.ProductVersionID
INNER JOIN
dbo.Product P ON C.CassetteID = P.ProductID
WHERE
(StyleCode = 'R' OR StyleCode = 'B')
AND
Religion IN ('G','S','B')
Why is there no way to do this using the LLBLGen predicates? It seems that I can only use another field/column as the value for the IN. This is the second time I've run across this problem and am wondering if there are any plans to allow this soon?