Thank you.

Both 'Total Server Memory (KB)' and 'Target Server Memory (KB)' gave the same result. Is it ok?

So casting to text/ntext (what I am currently doing) is the only way to do it?

Right. I suspect that normal vb/vb script would handle it ok, but Access has problems

By the way I'm sorry, I am using Sql Server 2008

It handles perfectly the other way - when I insert into SQL table and set the parameter

cmd.CreateParameter("@CaseSummary", adLongVarWChar, adParamInput, -1, IIf(IsNull(txtCaseSummary.Value), Null, txtCaseSummary.Value))

So Access 2003 handles something at least...

This is the driver I use

SQL Server Native Client 10.0 (SQLNCLI10.DLL)

Thank you DA, TB & GS!

The reason I asked is that in the past I had a problem with try/catch when parent proc did not catch the error in the...

Thank you guys!

WendellB, you are right 100%. However 1. I must use Access 2003 (corporate policy), 2. The information in the base tables is highly sensitive (confidential) so I cannot...

Thanks guys,

ProofOfLife ==> this is not the case, when I cast(Summary as text) everything's ok - no squares

WendellB:

1. Access 2003

2. I do not link SQL server tables to Access, I'm...

Thanks, I'll try ...

but this was a starting point - varchar(max) does not work in this context

Ha-ha! Select Cast(Summary as TEXT) worked! long live ME!

I understand that you want cut off all trailing characters starting from the first not numeric. I emulated a vb function Val using this code:

Create function [dbo].[Val]

(

@text nvarchar(40)

)

returns...

Thank you very much. I've solved the problem even before I posted my question. The scenario was

1) cut duplicatable records from the base table,

2) place them into a temporary table...

You are right. Null does not affect the result, so isnull is not necessary (especially - I do not want to change the data, I just want to remove duplicates,...