Database error: Invalid SQL: SELECT DISTINCT
brand.brand_id,
trim(brand.brand_name) brand_name,
brl.descr brand_desc
FROM srv_a_brand brand
LEFT JOIN srv_a_language brl
ON brl.table_id = 'srv_a_brand' and brl.table_pk_int = brand.brand_id
AND brl.language_id = 'fr'
WHERE lower(trim(brand.brand_name)) = lower(trim('ROY ROGER'S'))
PostgreSQL Error: 1 (ERROR: syntax error at or near "S"
LINE 11: ...E lower(trim(brand.brand_name)) = lower(trim('ROY ROGER'S'))
^)
Session halted.