thanks peso that did the trick 🙂

thanks ive just tried that on my table and i get the following error:

Arithmetic overflow error converting expression to data type datetime.

Here is the SQL, which I have replaced the...

Hi, ive just tried the code provided above and still the same result

ie

SELECT CONVERT(CHAR(10), STR('20070101', 8, 0), 111)

still results in 20070101....

hi,

I have jus tested this and it has acheived wat i want, i shud of tested it b4 replying back, apologies,

thanks for the replies

thanks for the reply, however this wont achieve my goal, becuase if the "key" is not null i want a inner join on the tables if not jus the select...

Thanks, both replies work 🙂

Thanks for you reply.

The reason is the date (a parameter to a report) which I am getting is in 2007/01/01 format however the date in the database is in int...