The N'A' means that 'A' is an Unicode string constant.

Unicode is using 2 bytes to encode each character.

The DATALENGTH function returns the number of bytes used to represent the expression.

So in this case, you have to multiply the number in the REPLICATE function by 2.

HTH,

Robbert