Thanks fo the reply.

I tried it in SQL2008 but still get an error like

SELECT CAST(0x002D248F00000000 AS datetime2) and ERROR is "Type datetime2 is not a defined system type"

and below...

Hi,

Thanks for the reply. I have little problem below. Now when I use the DISTINCT in SELECT than it says that I need to use columns that are...

Suppose I have a table called City_Table

and there is column called XCode and City and data is like

XCode                City

A                     Boaz

B                     Arab

C                     Calera

D                     Cordova

E                     FairField

F                     Arab

G                     Boaz

H                     Calera

I                      FairField

J                      Cordova

H                      FairField

Now what...

thanks for the reply

that means if my variable is of 5 characters than varchar(200) will occupy space of 5 characters right? not what is defined in datatype.