Are you able to get any records returned when passing your statement through VB? Could it be that the error isn't in your where statement but in your connection? I would test this by doing a simple select and see if you get the expected results first.





Reply With Quote