hi friends! I am facing a situation where I have to add 4 columns to create uniqueness for a datacomponent . I am trying to count ( disctinct a+b+c+d+e) now a= smalldatetime . when i remove small date time it is ok . but how i can convert smalldate time to add to other fields can you please suggest.