hi christian,
Christian Pesch schrieb:
Jakob Braeuchi wrote:
do you know what ms-sql does, when the first value is a string ? i'm thinking of using something like this :
'OJB' + col1 + col2
If col1 and col2 are the names of int columns, you have cast them like:
'OJB.' + cast(col1 as varchar(11)) + cast(col2 as varchar(11))
we cannot always cast to varchar(11). the bad thing is that number and string columns have to be treated differently :(
DB2 is completely different:
'OJB.' concat rtrim(char(col1)) concat rtrim(char(col2))
does db2 support || as concatenation character ?
i was using concatenation to circumvent the different flavors of distincts, but it seems that concatenation is as bad as distinct.
jakob
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
