is this correct will it do the or part if it cannot do the where part.<BR><BR>strsql = "SELECT * FROM ipcountry WHERE " & ipno & " BETWEEN ipFROM AND ipTO OR id="1""
What DB are you using?? What datatype is the field ipno.<BR><BR>By the way this SQL is not correct.
...it's the VBScript that is wrong.<BR><BR>He can't have a single " inside a "..." string. But he knows that; he's been told several times. Just being sloppy, I presume.<BR><BR>
I have seen the same SQL in numerous posts from him.