Concatinate in a Query

hi list,

I've got a question about concatination for Varchar2, in a query. I want to do something like this below :

update BlahBlah

set XQuery = 'select name || ' ' || family from ASDF'
where id =1               ^^^^^^^^^^

you see, I want to seprate the name and family in my query with a blank space, but it cause to terminate the update query.

what can I do to solve my problem ? is there any special character for blank space ?

any suggestion is welcome
best wishes,

Amin Emami Received on Sat Jul 13 2002 - 00:33:05 CDT