Hello:
This seems like it should be simple, but I am having trouble
figuring it out.
I have a table contact which has:
name String
contact_id int
Lets assume the contact table has this row:
name: Neil Aggarwal
contact_id: 1
I want to create a view that has this data
name: Neil Aggarwal
ref: C1
I did this:
create or replace view
view_AllData as
select
c.name
('C'+c.contact_id) as ref,
from contact c
but the ref does not have the leading 'C' in
the front of it.
Any ideas?
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
