aren't asking SQL to do datetime manipulation based on info imbedded
in a text field
Dick
On Mar 31, 2004, at 8:05 AM, cf coder wrote:
> Hi Guys,
>
> I'm strugging to display the data correctly from the
> comment column in the database and need your help. I
> want to display the top most comment from the comments
> table. Here is an example. In the example below there
> are 2 comments
>
> *** 13/01/2003��09:47:06��TUser1 ***
> callno:1126
> Some comment1
>
> *** 13/01/2003��08:30:27��TUser2 ***
> Some Comment2
>
> I want to display the TOP most comment. In this case
>
> *** 13/01/2003��09:47:06��TUser1 ***
> callno:1126
> Some comment1
>
> All comments have the ***, date time and user
> information
> "*** 13/01/2003��09:47:06��TUser1 ***"
>
> I would really apprecaite your help.
> Best Regards,
> cfcoder
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
