Help combining columns

Database
Enthusiast

Help combining columns

case when left(MM_OBJ_LOC_TXT,1) <> '/' then '/' + MM_OBJ_LOC_TXT else MM_OBJ_LOC_TXT end

i keep getting bad character format
1 REPLY
Enthusiast

Re: Help combining columns

I think "+" is only an operator for numerical addition. Strings in Teradata are concatenated using the "||" (two pipe characters) operator.