Er, so please explain what it is supposed to do and what it is doing that it is not supposed to do. And does the SQL that you have behave in the same way in query analyzer, if it does that is a sure sign that you do not have a Perl question but should ask somewhere else.

/J\