sql/vb statement help

Heres my vb code
Dim sql As String = "SELECT P_Name, C_PeriodTo from PROPOSER, POLICY where DATEDIFF(DD, GETDATE(), C_PeriodTo)>1 AND DATEDIFF(DD, GETDATE(), C_PeriodTo)<28 AND P_RegnNo=C_RegnNo"

However, the result is different from what I get using Sql Query Analyzser. May I know if there is any special characters in the code that might be causing the difference?

I originally wrote a bunch more, but now that I'm looking:

======================
AND P_RegnNo=C_RegnNo"
======================

These are not in the select statement. So the numbers are not going to match I believe. There will never be an equals? Do you not have to select these to be able to parse them?

Hope it helps!