I don't know for the %0\..\
I got weird thing the first time i try to use it, so i gave up.

For you time error, try this, it work like a charm

code:

SELECT
      CASE @TIME >= "00:00:00" AND @TIME <= "09:00:00"
      $TimeGreeting = "Good morning"
      
      CASE @TIME > "09:00:00" AND @TIME <= "18:00:00"
      $TimeGreeting = "Good day"
      
      CASE @TIME > "18:00:00" AND @TIME <= "23:59:59"
      $TimeGreeting = "Good evening"
ENDSELECT

[This message has been edited by Popovk (edited 22 May 2001).]

_________________________
? getobject(Kixtart.org.Signature)