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! From: [email protected] Sent: Thursday, March 20, 2014 6:51 PM To: [email protected] 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?
