I'm trying to get this code to work but it doesn't like the "%". If I remove it the query works but then my wildcarding disappears. Does postgresql use something different then % for wildcard characters? col17 is a varchar field so there shouldn't be any problems with spaces front or back. Not sure what else to check.
SELECT tbl3.col22, tbl3.col11, tbl3.col17
FROM tbl3 LEFT JOIN tbl4view ON tbl3.col1 = tbl4view.col13
WHERE tbl3.col17 LIKE '%a99%'