Hi I am trying to create a view in X3 using the following code

SELECT TOP (100) PERCENT ga.CCE_4 AS BPCINV, a2.TEXTE_0 AS BPCNAM, SUM(ga.AMTLED_0 * ga.SNS_0) AS NETAMTNOT
FROM FOLDERNAME.GACCENTRYD AS gd WITH (nolock) INNER JOIN
FOLDERNAME.GACCOUNT AS g ON gd.ACC_0 = g.ACC_0 INNER JOIN
FOLDERNAME.GACCENTRY AS gy WITH (nolock) ON gd.NUM_0 = gy.NUM_0 INNER JOIN
FOLDERNAME.GACCENTRYA AS ga WITH (nolock) ON ga.NUM_0 = gd.NUM_0 AND ga.LIN_0 = gd.LIN_0 AND ga.LEDTYP_0 = 1 AND
ga.ACCNUM_0 = gd.ACCNUM_0 LEFT OUTER JOIN
FOLDERNAME.ATEXTRA AS a1 WITH (nolock) ON ga.CCE_3 = a1.IDENT2_0 AND a1.CODFIC_0 = 'CACCE' AND a1.ZONE_0 = 'DESTRA' AND
a1.LANGUE_0 = 'BRI' AND a1.IDENT1_0 = 'SR' LEFT OUTER JOIN
FOLDERNAME.ATEXTRA AS a2 WITH (nolock) ON ga.CCE_4 = a2.IDENT2_0 AND a2.CODFIC_0 = 'CACCE' AND a2.ZONE_0 = 'DESTRA' AND
a2.LANGUE_0 = 'BRI' AND a2.IDENT1_0 = 'CUS'
WHERE (gd.ACC_0 LIKE '600%' OR
gd.ACC_0 LIKE '620%') AND (gd.LEDTYP_0 = 1) AND (MONTH(gd.ACCDAT_0) = 1) AND (YEAR(gd.ACCDAT_0) = YEAR(GETDATE()))
GROUP BY ga.CCE_4, a2.TEXTE_0
ORDER BY BPCINV

I am able to save the view however when I validate the view i get the application error below,

If I remove the % from the script it validates fine. Can wildcards be used within X3, if so what is the symbol?

Regards

Paul Moss