Developer forum

Hi Sergey

You shoulde be able to do like this:

SELECT * FROM area where areaid = CONCAT('1', '')

And how could i do something like this: 

DECLARE @variantId NVARCHAR(4)
SET @variantId='VO16'

DECLARE @variantName NVARCHAR(100)

SET @variantName = 'VariantName'

SELECT CONCAT(@variantId, @variantName)

I have an error (in attachment)

Hm, it works in my Firehose, see dump.

Could it be that your solution has a really old Database server, old database level, missing settings, missing permissions or someting similar - can you execute the query directly on your database?

BR Nicolai

Hi Nicolai,

 have a solution hosted on dynamicweb-cms.com so i don't have direct access to my database

Can you give me a link?

http://danskadelsforening.net.dynamicweb-cms.com/

by the way, could it depend on a browser? because i've tried it only in Chrome

Hi Sergey

This solution is hosted on SQL 2008 - the concat function is available in 2012+:

https://msdn.microsoft.com/en-us/library/hh231515%28v=sql.110%29.aspx

You can only Concatenate using +  in 2008

I've tried to execute the same query but without CONCAT  - the last string is

SELECT @variantId + @variantName

on sql server v. 2008 r2 and it does work but it doesn't work on Firehose: i have another error (in attachment) and if i just remove "+ @variantName"  - all works as it should. 

Thank you for your help!