Search results for query: *

Fantastic just what I need thanks Nigel

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...

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...

ideally i want to define a new column, which isnt held in the database which should hold my new value (the results of the if statement) In this column i want the output of the if statment eg Query select id_no, account, balance, odlimit from table a IF ((odlimit = '00' AND balance < '00')...

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

thankyou so much guys, that helped a lot and have now got the exact data I need.

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...

Thankyou your an absolute star :)

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...