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 TouchToneTommy 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: CSOP
  • Content: Threads
  • Order by date
  1. CSOP

    Date:time

    Hi There, I've got a field expiry_date which is type date:time. This field contains all variety of dates. I would like to find all data which has an expiry date in March i.e like '1998-03-31 00:00:00' or like '____-03-__ 00:00:00' when I carry this query out I get no result returned...
  2. CSOP

    Show double fields

    Hi There, I'm having trouble with some data manipulation and hope someone out there can help? I've got a table which has fields: customer_number account_number, address, currency A customer number is unique to each customer, however a customer can have more than one account associated with...
  3. CSOP

    displaying if statement as a column

    Hi there, Does anyone know if it is possible to do this. eg: IF ((ColumnA <ColumnB)OR (Column A <ColumnC)) AS CALC Many thanks
  4. CSOP

    table joining problem

    Hi, I'v got 2 tables: table a and table b. Both have the same primary key which is a unique reference number. However table a is general, and has every single refernce number, and table b is specific to a particular area in the dbs, and represents data which comes under a specidic category...
  5. CSOP

    Date query

    Hi I'd like to know if there is an option where i could compare a specific date with the most recent date as the days change ie a non static variable. Is there a variable like this (ie which acts like a calender and compares my selected feild with the changing days)? eg. select * from table1...

Part and Inventory Search

Back
Top