I did use the SP to do following:

exec dbo.usp_httppost 'http://froogle.google.com/froogle','q=nokia&btnG=Search+Froogle'

and got no results. But the original URL resturns data. The original URL is:

http://froogle.google.com/froogle?q=nokia&btnG=Search+Froogle

Here is what I got:

return_status,error_msg,HTTP_Status,HTTP_AllResponseHeaders,HTTP_ResponseText

0,DONE,200,Set-Cookie: PREF=ID=1b28c916df48a269:TM=1153416500:LM=1153416500:S=LXwmzermeNkwWDpt; expires=Sun,...

Stuff is NOT working with image data type, you CAN'T append binary data into image data with STUFF.

Thanks, Newbie. Maybe the question is too hard or I am in wrong direction.