Concatenate...

• b_boy

  SSCertifiable

  Points: 5145

  More actions

  November 4, 2008 at 11:15 am

  #201135

  hello

  I am trying to Concatenate two fields within the same table to give me a new column, but when i run the query get the following error message:

  Msg 451, Level 16, State 1, Line 2

  Cannot resolve collation conflict for column 35 in SELECT statement.

  Does anyone know why?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 4, 2008 at 11:29 am

  #893781

  The two fields have different collations is all I can come up with not having the DL for the table. Script the create statement for the table and look at the collation for each of the columns.

  You may want to post the DDL if you want addtional help.

• b_boy

  SSCertifiable

  Points: 5145

  More actions

  November 5, 2008 at 3:01 am

  #894098

  Hiya

  I checked it as you advised, and found that they had different collations, is there a way around this with changing it from the engine but within my query?

  [FitID] [nvarchar](50) COLLATE Latin1_General_CI_AS NULL,

  [SizeID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

• Tom Schuettke

  SSCarpal Tunnel

  Points: 4127

  More actions

  November 6, 2008 at 9:58 am

  #895044

  I tried to recreate your problem based on the information given and it concatenates the columns without error.

  You'll need to post the DDL so prople can understand the problem.