Thanks...

We just got it as well. Although we used convert. Thanks for the response. I am always impressed on this forum.

Andrew

Well, I got the date in...

with SELECT Convert(VarChar(8), a.item)

SSCarpal Tunnel,

Thanks for your post. I have used your format to parse the data.

Thanks again for your help...

This is a piece to my thesis of setting up a geographic...

Genius.....

Thanks man.....