David Emerson
davide at dalyn.co.nz
Mon May 24 19:42:17 CDT 2004
Found the problem - I had a CAST(@txtAct2yyyymm AS nvarchar(6)) which must have converte dthe whole variable to nvarchar. Changing it to varchar solved it. David At 25/05/2004, you wrote: >SQL2000. > >I have the following declaration in a stored procedure - > > declare @qs varchar(8000) > >However, when I assign a string to the variable it seems to truncate at >4000 characters. My understanding is that varchar can have up to 8000 >characters. Is there something I am missing? > >Regards > >David Emerson >Dalyn Software Ltd >25 Cunliffe St, Churton Park >Wellington, New Zealand >Ph/Fax (04) 478-7456 >Mobile 027-280-9348 _______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > > Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Churton Park Wellington, New Zealand Ph/Fax (04) 478-7456 Mobile 027-280-9348