>Hi All:
> I am trying to use a group by function in a view,however one of the filed in a view is text datatype, which stops me from grouping the data. Thus, how can group the data where one of the field is of text?
You cannot grou on text field in SQL Server as you cannot group on memo field in VFP.
--sb--