I have a very simple Concat query, it works on Standard Edition , but when I am migrating to Web Edition, this query does not work. (it does not concatenate) query : select [disbursements] + 'xyz' from Results. and disbursements is nvarchar datatype. I have tried concat, creating a new column with , nothing seems to be working, so far only substring turned out to help with concat, however I am struggling to substring the string and more importantly why would it work on Standard and not on Web Any help appreciated
Hi, I am using Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.3 (Build 9600: ) edition for standard and for web Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Copyright (c) Microsoft Corporation Web Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor) There is no error, it just does not concatenate the nvarchar(4000) with any string. My query is select [disbursements]+ 'xyz' from Results. This runs on the Standard edition, however when I run it on the Web edition, it does not concatenate. I have tried + , concat function, creating a new column for 'xyz' and then concatenating the 2 columns, none of these seem to work. Only if I substring the disbursements column and then concatenate with 'xyz' it works. I was assuming there are some /n or carriage return characters so have removed them still concat not working. So just wondering if Web edition has any limitations with + or concat, as it seems to work perfectly on Standard
To my knowledge there are no limitations/bugs. But try this code: select convert(varchar(100), [disbursements]) + 'xyz' from Results There may be some upper ascii characters in your disbursements field that you can't see. This won't clean it up, but may force it to work while you can research the data.