Re: Comparison

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 17:15:24 -0600

That would be correct. A simple example:

SET ANSI_WARNINGS OFF
DECLARE @v VARCHAR(20), @c CHAR(20), @nv NVARCHAR(20), @nc NCHAR(20)

SELECT @v = 'ABC ', @c = 'ABC ', @nv = N'ABC ', @nc = N'ABC '

SELECT LEN( @v ), LEN( @c ) ,
       LEN( @nv ) , LEN( @nc ),
       DATALENGTH( @v ), DATALENGTH( @c ) ,
       DATALENGTH( @nv ) , DATALENGTH( @nc )

SELECT CASE WHEN @v = 'ABC' THEN 'Trims' ELSE 'No' END AS "vc",
       CASE WHEN @c = 'ABC' THEN 'Trims' ELSE 'No' END AS "c",
       CASE WHEN @nv = N'ABC' THEN 'Trims' ELSE 'No' END AS "nv",
       CASE WHEN @nc = N'ABC' THEN 'Trims' ELSE 'No' END AS "nc" ; 

-- 
Anith