List:General Discussion« Previous MessageNext Message »
From:Neil Aggarwal Date:November 25 2009 1:43am
Subject:RE: How to concatenate a constant to an int?
View as plain text  
>         concat('C',c.contact_id) as ref

That worked.  Thanks the the tip.

Now, lets say I have three tables:

contact
	contact_id int

prospect
	prospect_id int

client
	client_id int


If a contact is a prospect, it will have a line in
both the contact and prospect table, with the same
id value.

If a contact is a client, it will have a line in
the contact, prospect, and client table, all with
the same id value.

For example:

	contact_id 1

	contact_id 2
	prospect_id 2

	contact_id 3
	prospect_id 3
	client_id 3

I want the ref numbers to be:
	C1
	P2
	L3

Is there a way to use a query to do that?

Something like:

create or replace view
view_AllData as
select 
	concat('C' or 'P' or 'L',c.contact_id) as reference_number,
from contact c
left join prospect p on c.contact_id = p.prospect_id
left join client l on p.prospect_id = l.client_id

Any ideas how to do this?

Thanks
	Neil	

--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial 

Thread
How to concatenate a constant to an int?Neil Aggarwal25 Nov
  • Re: How to concatenate a constant to an int?Michael Dykman25 Nov
    • RE: How to concatenate a constant to an int?Neil Aggarwal25 Nov
      • Re: How to concatenate a constant to an int?Michael Dykman25 Nov