Hi Allan,

You're welcome.

>Sergey,
>
>Like always - right on the money! Thanks for your assistance yet again.
>
>Al
>
>>Hi Allan,
>>
>>When you concatenate string (char, nchar) with other data types, SQL Server may perform implicit conversion of those types to the char/nchar. In BOL CAST and CONVERT there's a chart that shows all explicit and implicit data type conversions allowed for SQL Server system-supplied data types. According to it, money data type can be converted to nchar only explicitly (CAST or CONVERT).

	(TransactionDetails.AmountMN Between '+
>>         CAST(@LowAmountMN AS nvarchar(32) + ' AND '+
>>         CAST(@HighAmountMN AS nvarchar(32)) + ')' +

I prefer always use explicit conversion so I can control result of it.
>>>