| Subject | Concatenate integer and string in SQL |
|---|---|
| Author | |
| Post date | 2014-03-20T17:51:48Z |
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?
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?