Hai,

1.  SQL Server Version 7.0

2. If Records are more i am  not getting as below

 -text1-text2-text3

i am getting only  - text3

This is for your information.

My table Table1 consists of  following structure

ECode        EName     E_mailID

1            abc            abc@1.com

2            bc            bc@1.com

...

...

120       xyx          xyz@1.com

when i use the following query

declare @StMail as varchar(8000)

set @StMail= ''

select @StMail=...

I am facing the same problem. I want to know

what is "Blat".

Awaiting for your reply

quote:

---

No I haven't because I wanted to...

hi ,

i used the below code u suggested.

DECLARE @text varchar(8000)

SELECT @text=EmpMast_Signature FROM hr_empmast where EmpMast_Code=6

print @text

here EmpMast_Signature is of image datatype

but it is giving error

Operand type clash: image is...

OK Thanks

Cascade delete is a dangerous one,Before delete you should be careful, because there may be references.