I do actually state -

Luis Cazares (5/20/2014)

Though...

Fair point I guess. As the SQL i am using is not dynamic then it's a moot point at best, even when I have though It still doesn't necessarily...

Erikur - I disagree that it simplifies the script, what is wrong with the following that needs simplifying? Even more complex SQL statements with multiple tables, joins and sub-queries,...

You can install the Developer Edition on Windows 7, XP so i'm guessing Vista would be okay too. I have SQL 2008 Developer Edition on my Win 7 machine.

That is true, that is why i added the word "like" to my comment, i actually have these in the SQL - sorry if i gave the impression that...

Thanks for all the help, but i have done is something like

SELECT *

FROM tablea a

WHERE a.value ='xxx'

OR a.EndDate < '24/08/2010'

AND a.EndDate = '24/08/2010'

AND...

Steve,

"Steve

As I understand it, the actual data Gordon is working on does not have a Date or Datetime field but rather a char(10) field holding English style dates such as...

It would seem that joining the date and time is the only way;

SELECT

CONVERT(char(10), YearChar, 103) + ' '+ CONVERT(Char(8), tbl_DateTime.Time,13),

Cast(tbl_DateTime.Time as char(8))

FROM

tbl_DateTime

WHERE

CONVERT(char(10),...

Old Hand,

Whilst that will work, i did actually state on the initial post "i don't wish to go down the route of creating a date time field along the lines...

Ron,

If the date is 23/08/2010 the subsequent time field for that row will define if it is night shift or not so a single row would have the following

Date ...