Concatenate the column values in query result as a single string 1

[bean1234]

Hello All,

I am trying the following query

select first_name + ' ' +middle_initial+ ' '+last_name as name, user_ids.racfid from user_ids,user_roles  where user_ids.racfid = user_roles.racfid and user_roles.role_name = 'Publisher'

I get an error ORA-01722: invalid number, as you can see I ma trying to concatenate the name fileds and return it as a single field.Please let me if its possible and if not anyother way to do it .

Thanks in Advance!

 

[bean1234]

Forgot to mention I am using oracle 9i.

Thanks.

 

[lewisp]

Change + to ||.