thank you so much, Addict. That's very good info. I never knew the stuff function before.

Before I got your post. I did in this way.

update log set content='acct='+substring(content, 15, 190)...

what function I can use to delete certain number character in the string if I can locate the start position of the character.

Thankyou

Betty

I guess in the replace function, the search string cannot be search string pattern format?

Greg,

thank so much. that's good informaiton for me. I just noticed that content column is actually varchar(200).

Do you see any defect in my sql statement?

Thank you.

very strange, I cannot even update.

Is it because it is text field?

what should I do then?

Thank you.

Betty

Thank you very very much, Kishore.

Very clear and informative. I will do that and I don't want to be bothered any more.

Betty

Hi Paul,

Can you tell me the detailed steps how to set this kind of account?

Thank you.

Betty

Bledu,

I think you are right. My problem is I usually don't check what's the service pack I need to apply at the right time. Sometime I am afraid of doing...

thank you for all your postings and contribution. Yes, basically there should be a way doing this in data access layer not application layer. I got this in microsoft aspnet discussion...

SQLBill,

Good point, I will follow the good practice in programming.

Betty

Wow, good catch, I thought it shouldn't matter.

The error messages never give me any clue. I delete the parameter in store procedure.

Thank you, thank you.

Betty

Bledu,

Can you provide more information, link or article about xml.

Thanks

Betty

Hi all,

Thanks all for your postings, that's a great help to me.

Yesterday, I googled for a while, then an article gave me an idea,just like

Hi,

I tried to create a specific suggested by David. I am not sure if I did the right way.

In enterprise manager, I add a role under the database "aspnetprogram", it...

Wow, that's great! I guess you programed against database very often, otherwise how come you know master database? Thank you.

Betty