You can truncate the time part and simplify the calculation in one swell foop:
select DateAdd( m, DateDiff( m, 0, @NextMonth ) + 1, 0 );
Leave out the "+ 1" and you get the first day of this month.
Tomm Carr
--
Version Normal Form -- http://groups.google.com/group/vrdbms