Stored Procedure for delete

[ran]

Hi,

I need to create a stored procedure which would
delete just the photo of a student once he graduates.
I found out that a delete SQL statement will delete a whole row.
Is there a way to just delete the Photo and leave the rest of the data
untouched.

Thanks.

Regds,
Ran

[Louis Cypher]

I believe UPDATETEXT is what ur looking for


------------
ran at 7/25/01 2:25:18 PM

Hi,

I need to create a stored procedure which would
delete just the photo of a student once he graduates.
I found out that a delete SQL statement will delete a whole row.
Is there a way to just delete the Photo and leave the rest of the data
untouched.

Thanks.

Regds,
Ran