Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: petergroot
  • Content: Threads
  • Order by date
  1. petergroot

    problem with case-when-then-else syntax

    Hi, I have a Produkt table with 2 prices (ordinary price and special offer price) in the table there is also a boolean which determines if the produkt is on sale or not. Now i want to write an SQL line that pulls out the Special Offerprice when the boolean is true. I understand that i need...
  2. petergroot

    Date format

    Hi, I let the user input a date in the calender dirct-x control, but i want to format the date to a long date (f. ex. 10 oktober 2002) but when i use cdate(date), then i get 10.10.2002 as ouput. Can somebody help me out here? Thanks in advance, Peter

Part and Inventory Search

Back
Top