Re: delimiter for user inputs
From: Anurag Varma <avdbi_at_hotmail.com>
Date: 27 Aug 2001 21:35:19 -0700
Message-ID: <7171ca2d.0108272035.5653b2a9_at_posting.google.com>
Date: 27 Aug 2001 21:35:19 -0700
Message-ID: <7171ca2d.0108272035.5653b2a9_at_posting.google.com>
Don <don_at_xxx.com> wrote in message news:<sk7lot0q49jldae0bbj9ohlqias6vji5cs_at_4ax.com>...
> I am trying to let the user enter a value which is a DATE type
>
> Update anytable
> set StartDate = &UserInputDateValue ;
> but how could I code it to have the user just
> type in ------> 23-MAR-01
> WITHOUT having to type in the single quotes around the date value
Try
Update anytable
set StartDate = '&UserInputDateValue' ;
Yes :) Code the single quote in the update itself
Anurag Received on Tue Aug 28 2001 - 06:35:19 CEST