how about
update BlahBlah
set XQuery = 'select name ' || ' ' || ' family from ASDF'
where id =1 ^^^^^^^^^^
That should work
Jim
"Amin Emami" <amin_emami_at_yahoo.com> wrote in message
news:6f13a27a.0207122133.1b72a0fc_at_posting.google.com...
> 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 - 01:10:07 CDT
