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))
DB2 is completely different:
'OJB.' concat rtrim(char(col1)) concat rtrim(char(col2))
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
