Hello,


When writing a text to a SQL database nvarchar(6) field, I get following
error when the size of the input is larger than the available length of the
textfield (larger than 6).

String or binary data would be truncated.
The statement has been terminated.

How can I make that at least the first 6 characters will be saved and the
input is indeed truncated without generating an error or at least to catch
the error silently?


Many thanks and greetings,

Michel

[quoted text, click to view]
See if your database supports a left() or substr() function, or do this in
your VB code.