Thanks ever so much - just the reply I was searching for!!! I can use this reasoning in my report!

Thanks for replying Fhanlon,

I have got quite a good grip of the different RAID levels. However, I am more confused about the differences between RAID redundancy and database replication. We...

This is the final view (I have been working in query analyser and when I pasted the results in a view, CROSS JOINS were used - do these produce a...

So in essence, I would be performing 2 conversions regardless of which method i use? And as you mentioned that dates are naturally stored as numbers, a number conversion will...

I seeeeee. Yes, that makes sense. I was thinking that I would be changing the field value as opposed to the data value (the column is a datetime datatype, by...

Kokyan,

If I have converted the date to a varchar, can I still query the value with other date values?

For example, I have to extract the records from the...

Thanks! As performance is an ongoing issue, any improvements, no matter how trivial, are always helpful!

Bex

Thanks ever so much for your rapid reply Kokyan! I shall get on the case now! I can see I shall be a regular here!

Bex