ok. Why you still using sybase 10 ? Why can't ask your manager to upgrade it to 15.2(latest version) or atleast 12.5.3 ( which is having lot of features...

Hi, thanks for your help

However, I could not run your codes in my system. There's always error message shown "Incorrect syntax near the...

It's strange that I could only get "/yunxxxx@hotmail.com" with exactly the same code as you...

Well, I'm using Sybase 10 and Embarcadero DBArtisan 8.1.2, maybe Sybase...

Hi, I just use your codes, you can try on your system

create table Email_ID

(

CustomerID varchar(30),

Address varchar(50)

)

insert into Email_ID

SELECT 'HK08012698','edxxxxx@gmail.com' UNION ALL

SELECT 'HK08012698','kimxxxx@gmail.com' UNION ALL

SELECT 'HK08012698','yunxxxx@hotmail.com' UNION ALL

SELECT 'HK08012699','sallyxx@gmail.com' UNION ALL

SELECT...

I tried and got the result "/ed9xxxx@gmail.com", it seems the @add could only store the last record.

Hi, karthikeyan, thanks

However, I could only get the " ed9xxxx@gmail.com" with your codes...

Thanks for your suggestion!

I'm new to SQL and SP, will read the article to see whether I could apply it in my case...

I want to get the following result sets:

In table address, there are several rows to store different E-Mail addresses, for example:

customer_id ...

Hi, for table #tmp_410a, I retrieve some information from several tables and store the data into this temprary table:

select

ad.address_id,

ca.customer_account_id,

ca.customer_account_title,

......

convert(varchar(100), '') email,

......

into #tmp_410a

from ...

Thanks, Ken

Someone else suggests a much simpler way:

change

case when charindex('(', asset.asset_name) > 0 then

left(asset.asset_name, charindex('(', asset.asset_name) - 1)

else

...

Just now, I tried to use another SP to do the "update" command, and call it in the original SP, however, still no use...

I was confused and lost~~~

I'm working with 9453...

Here is the error message:

Number (208) Severity (16) State (1)...

Hi, Sergiy, thanks for your kind help!

Well, I did not understand your meaning of "cross join"...

And, it still did not work...

First, there is "error" message with update t1

as "t1"...