How to post a null date variable to a table

[Arden Weiss]

How to post a null date to SQL Server 2000 via a variable instead of just using the word "Null" or do I have to use an embedded CASE statement.

<CFQUERY NAME="UP2" DATASOURCE="test">
  UPDATE mytable
  SET
  APPL_DATE = #APPL_DATE# , <-- This has a valid date and works fine
  APRV_DATE = Null          <-- This posts a Null Date to "mytable"   
  WHERE L_NUMBER = '#mFINDIT#'
</CFQUERY>

Hope the question is clear...

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---