Hi, <BR><BR>I used ASP to write one ODBC (not Oracle)SQL statement to get information from one table. There is one null value in one field. Could anyone tell me how to convert null value to 0 using ODBC? I tried ISNULL, NULLIF but did not work. Thanx.