How to make my between statement work in ASP/VB Script

[Cerebral88]

This works in Access. I understand that you cannot use the NZ function with ASP/VB Script.Does anyone know how I could make this SQL statement work in my ASP page using VBSCIPT.\[code\]BatterGames = rsBatQual("TotalPA")DIM rsBatterLU, sqlBatterLUsqlBatterLU = "SELECT games FROM tblLookupPSBatters "sqlBatterLU = sqlBatterLU & "WHERE ((('" & BatterGames & "') Between Nz([minVal],-999999) And Nz([maxVal],999999)));"set rsBatterLU = Server.CreateObject ("ADODB.RecordSet")rsBatterLU.Open sqlBatterLU,conn \[/code\]Thanks