/other/old_site_member_blogs/bentley_employees/b/jo_wests_blog/posts/concatenating-attributes-in-an-environmentA simple way to concatenate or combine two or more attributes in an environment would be to use the update option of the attribute properties. For example, let&#39;s say the environment has two varchar attributes attr1 and attr2 and we want to combine thenen-USTelligent Community 12https://communities.bentley.com/other/old_site_member_blogs/bentley_employees/b/jo_wests_blog/posts/concatenating-attributes-in-an-environmentFri, 15 May 2009 17:50:02 GMT6dad98f5-dbc9-4c4d-a9ba-e9da8dc6aa8e:984ebc56-ef46-4c9b-96a6-5537ee1e1b13Kestas1<p>One way of getting rid of '-' for SQL Server:</p> <p>select case when len('$EDIT#attr1$') * len('$EDIT#attr2$') &gt; 0 &nbsp;then '$EDIT#attr1$-$EDIT#attr2$'else '$EDIT#attr1$$EDIT#attr2$' end </p> <p>and for Oracle:</p> <p>select case when nvl(length(trim('$EDIT#attr1$')),0) * nvl(length(trim('$EDIT#attr2$')),0) &gt; 0 then '$EDIT#attr1$-$EDIT#attr2$' else '$EDIT#attr1$$EDIT#attr2$' end from dual</p> <img src="https://communities.bentley.com/aggbug?PostID=29622&AppID=31477&AppType=Weblog&ContentType=0" width="1" height="1">