>In this case the parameter is "text" but the string is truncated to 16 characters only.
>
>Does somebody know why?
It is probably due to the fact that text fields are handled with "pointers". The pointer is a 16-byte value that tells SQL Server the location of the actual text.