yeah we solved it...i was just intrigued by the purported standard "SQL"
example in the CF tutorial
> Hmmmm, I don't know excatcly what you are trying to do, but I don't think you can use
> the Cold Fusion function Left.
>
> Try using the PostgreSQL function substr() instead, as someone else suggested.
>
> Poul L. Christiansen