# Toad for SQL Server

**URL:** <https://forums.toadworld.com/t/toad-for-sql-server/27732>\
**Category:** Toad for SQL Server\
**Created:** [November 20, 2013, 3:54am UTC](https://forums.toadworld.com/t/toad-for-sql-server/27732 "2013-11-20T03:54:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![p.bellaver](https://avatars.discourse-cdn.com/v4/letter/p/91b2a8/32.png) [@p.bellaver](https://forums.toadworld.com/u/p.bellaver)\
**Post date:** [November 20, 2013, 3:54am UTC](https://forums.toadworld.com/t/toad-for-sql-server/27732/1 "2013-11-20T03:54:59Z")

</div>

hello, I’ve still installed Toad for SQL Server, and executing the following select

select CONCAT(‘BPF’, t\_suno\_c) from ttfgld902702 ;

using Concat() function the system take me the following error:

"lookup error - SQl Server database error: ‘CONCAT’ is not a recognized value of predefined function

(transated from italian language: “CONCAT non è un valore riconosciuto di funzione predefinita”).

I’ve get function from the Code Snippets tab in the “String Functions” group.

probably there’s some configuration steps to do, but I don’t found a solution.

I’m not yet able to do a join between strings also usine “+” connector.

I’ve a lot of experience in sql languages, also with Toad for Oracle, but I don’t understand where is the problem.

can someone help me?

thnks in advance, Pietro

---

<div class="post-metadata">

**Author:** ![wzubke](https://avatars.discourse-cdn.com/v4/letter/w/50afbb/32.png) [@wzubke](https://forums.toadworld.com/u/wzubke)\
**Post date:** [November 21, 2013, 5:13am UTC](https://forums.toadworld.com/t/toad-for-sql-server/27732/2 "2013-11-21T05:13:20Z")

</div>

MSSQL does not support the CONCAT function. The CONCAT function is used in MySQL. You must use the + operator.

SELECT ‘BPF’ + t\_suno\_c as [FieldName] from ttfgld902702

If t\_suno\_c is not a string field you may have to convert

SELECT ‘BPF’ + convert(varchar,t\_suno\_c) as [FieldName] from ttfgld902702

Another trick is using FN to make CONCAT compatible with MSSQL. This method only allows 2 values be based in

SELECT {FN CONCAT(‘BPF’,t\_suno\_c)} as [FieldName] from ttfgld902702

Hope this helps!

**Riverwood Healthcare Center**

**200 Bunker Hill Drive**

**Aitkin, MN, 56431**

[**www.RiverwoodHealthcare.org**](http://www.RiverwoodHealthcare.org)

Wade D Zubke  
**IT Clinical Data and Report Analyst**  
ph: **218-429-3982**  
fax: **(218) 927-5516**  
**[WZubke@riverwoodhealthcare.org](mailto:WZubke@riverwoodhealthcare.org)**

**From:** p.bellaver [[mailto:bounce-pbellaver@toadworld.com](mailto:bounce-pbellaver@toadworld.com)]  
**Sent:** Wednesday, November 20, 2013 9:25 PM  
**To:** [sqlserver@toadworld.com](mailto:sqlserver@toadworld.com)  
**Subject:** [Toad World - SQL Server Discussion Forum] Toad for SQL Server

**[Toad for SQL Server](http://www.toadworld.com/platforms/sql-server/f/54/t/20805.aspx)**

Thread created by p.bellaver

hello, I’ve still installed Toad for SQL Server, and executing the following select

select CONCAT(‘BPF’, t\_suno\_c) from ttfgld902702 ;

using Concat() function the system take me the following error:

"lookup error - SQl Server database error: ‘CONCAT’ is not a recognized value of predefined function

(transated from italian language: “CONCAT non è un valore riconosciuto di funzione predefinita”).

I’ve get function from the Code Snippets tab in the “String Functions” group.

probably there’s some configuration steps to do, but I don’t found a solution.

I’m not yet able to do a join between strings also usine “+” connector.

I’ve a lot of experience in sql languages, also with Toad for Oracle, but I don’t understand where is the problem.

can someone help me?

thnks in advance, Pietro

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/platforms/sql-server/f/54/t/20805.aspx?subscribe=false) on this subject.  
Or [Unsubscribe from SQL Server](http://www.toadworld.com/platforms/sql-server/f/54.aspx?subscribe=false) notifications altogether.  
Toad World - SQL Server Discussion Forum

[Flag](http://www.toadworld.com/platforms/sql-server/f/54/t/20805.aspx?AbuseContentId=087f39b2-a98c-4e0d-913e-a394d6ba7c97&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse.

![](http://gyk.r.mailjet.com/b74fe340/5Iai4d.gif)

---

<div class="post-metadata">

**Author:** ![rauldvlpr](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@rauldvlpr](https://forums.toadworld.com/u/rauldvlpr)\
**Post date:** [November 26, 2013, 3:52pm UTC](https://forums.toadworld.com/t/toad-for-sql-server/27732/3 "2013-11-26T15:52:39Z")

</div>

The function CONCAT is only in SQL Server 2012, maybe your instance that these connected is another version.