Add prefix text to select statement

Question

I am trying to run a select statement on two different servers that have some matching primary keys. I want to be able to select the primary key but add the prefix 'A' to every record

ex:

ID   "to this"   ID
1                A1
2                A2
3                A3

This is what I have for the query

select 'A' + CAST (a.id AS VARCHAR(25)) as ID,a.*,':',     b.*,':',c.*,':', d.*,':', e.*,'REPORTDT', g.*
from labgen.order_ a
join patient b on a.id = b.chart
join insurance c on b.ins1 = c.code
join client d on d.num = a.client1
join salesgrp e on d.salesgroup = e.num
join reportdt g on a.accession = g.accession

select CONCAT('A',a.id). You are correct sir, don't know why i couldn't think of this — user2168066, Sep 13 '16 at 16:16

score 0 · Accepted Answer · edited May 23 '17 at 10:29

0

Try this in the select statement:

select CONCAT('A', a.id) as ID, a.*,':', //etc

This link will also help.

edited May 23 '17 at 10:29

Community

1
1

answered Sep 13 '16 at 16:15

The One and Only ChemistryBlob

7,864
10
36
69

well that first line can't all be a concat as I see it – Drew Sep 13 '16 at 16:16
It's not, I just wrote the part of the query before the first comma – The One and Only ChemistryBlob Sep 13 '16 at 16:17
Yea I see what you mean, there isn't a need for CAST() in this situation – user2168066 Sep 13 '16 at 16:19

Add prefix text to select statement

1 Answers1