Subject Re: [firebird-support] Weird behavior of case when using string as return
Author Nando Dessena

J> Why is the 'short' string right-padded to length of 'looooooooong'? Can I
J> remove this spaces using some easy steps (i.e. not using rtrim UDF, ...).

I think that string literals like 'looooooooong' and 'short' evaluate
to the char type. If you want a different type (like varchar) you'll
need to cast() them.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at