I'm working on some ListX code, and it's been a while since I've had to work with it, and for the life of me I can't get this to work.

In my query pane I've got a query (kept short for brevity)
SELECT
TemplateCode = T.TemplateCode
FROM
xxxxx

In Format Pane:

<a href='http://somesite[FORMAT,\[TemplateCode\],{TRIM}].com' target="_blank">Link</a>

The problem is that the TemplateCode column in the db is a char 10 field and I'm geting back the value in the template code field followed by x number of blanks until I get's 10 characters..

Now I COULD just do a CAST on the value in the SQL call, and that works, but I'm trying to get the TRIM statement to fire... I feel it's something with my escape sequence, but I'm not seeing what I'm doing wrong.

Thanks.
Rick