woodsmailbox wrote:

> is there any shortcut to make 'x' a varchar instead of char in sql
> expressions? for instance,
>
> decode(1 = 1, 'a', 'ab')||'c'

These come to mind:


case when 1 = 1 then 'a' else 'ab' end || 'c'

or

trim(decode(1 = 1, 'a', 'ab') || 'c'


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com