Hi!
text on the SQL Server is for text only. There are some SQL Server tools to allow smart serach on the sql server text field (I don't remember exactly, it seems they appeared in SQL Server 2000).
image field type (blob) is for binary data. Don't try to store binary data into the text field, because SQL Server will corrupt them by removing some binary codes (at least C50A if I remember correctly).
See also my FAQ article for VFP on how to store binary data in image field in VFP.
>Hi there,
>
>Can somebody telle me what the difference is between a blob and a text or memo-field ??
>
>Greets from Holland
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.