הוספת שדות רשות לדאטאבייס

הנה : ….

SQL = "insert into Customers(id,nick,password,first_name,last_name,City,street,home,zip,phone,cell,email) Values ("
SQL = SQL & "'" & ValidSQL(request.Form("id")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("nick")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("password")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("first_name")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("last_name")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("city")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("street")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("home")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("zip")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("phone")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("cell")) & "',"
SQL = SQL & "'" & ValidSQL(request.Form("email")) & "')"
MyConn.Execute (SQL)

במקרה זה לדוגמא :
אם אני לא רוצה לחייב את הלקוח להזין מיקוד(ZIP)
וערך התא "".

בבסיס הנתונים ZIP מוגדר כמספר.

תודה