Concat not working on Web Edition

Question

question

DSukh asked Apr 29, '16

Concat not working on Web Edition

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[4000] 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

concatenation substring

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sjimmo commented · Apr 29, 2016 at 03:29 PM

What version of SQL Server are you using, both Standard and Web? Also, what is the sql code that you are trying to use?

0 ·

ThomasRushton ♦♦ commented · Apr 29, 2016 at 03:41 PM

and what error message are you getting?

0 ·

Answer 1 · 2016-05-01T14:06:45Z

borispinsky answered May 1, '16

Concat function was added in sql server 2012. So if your web edition is lower then 2012 use " + " instead

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2016-05-02T08:15:28Z

DSukh answered May 2, '16

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

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

srutzky commented · May 04, 2016 at 03:50 PM

This is not an answer. This is additional detail that should be added to the main question. Please update the question with this info and then delete this answer.

1 ·

Answer 3 · 2016-05-02T11:39:16Z

sjimmo answered May 2, '16

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.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

borispinsky commented · May 02, 2016 at 12:10 PM

Do you have nulls in disbursements column? try to use isnull().. select isnull([disbursements],'') + 'xyz' from Results

0 ·

Answer 4 · 2016-05-03T12:18:16Z

DSukh answered May 3, '16

I tried the above, but it is still not concatenating and no errors either

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

srutzky commented · May 04, 2016 at 03:48 PM

Why are you posting new answers as responses to comments? You should add comments on other people's answers in reply to them and/or update your question with additional details. Please add your responses to those areas and delete these answers. Thanks.

1 ·

question