| Subject | Re: [firebird-support] Concatenate integer and string in SQL |
|---|---|
| Author | Martijn Tonies (Upscene Productions) |
| Post date | 2014-03-20T17:53:58Z |
Hi,
Use the “double pipe”: ||
With
regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: dressel@...
Sent: Thursday, March 20, 2014 6:51 PM
Subject: [firebird-support] Concatenate integer and string in
SQL
FB 1.5
The following SQL (and variations of it) consistently fail to run (where ClientNameis a domain defined as varchar(20), and Client_ID is a integer):
Update ClientInfo CI
set ClientName= 'A' + cast(CI.Client_ID as varchar(10))
How can I update ClientName?