Is there a way of doing something like this

SELECT DISTINCT LIST(CAST(_fkCompanies AS VARCHAR)) _Restrict FROM Calls WHERE _fkProjects = 3

I want just the distinct _fkCompanies in the LIST eg the table might contain 1,2,4,2,1,6,7,8,1,2 etc and I want 1,2,4,6,7,8

Roy Lambert

"Roy Lambert" wrote
> Is there a way of doing something like this
>
> SELECT DISTINCT LIST(CAST(_fkCompanies AS VARCHAR)) _Restrict FROM Calls
> WHERE _fkProjects = 3
>
> I want just the distinct _fkCompanies in the LIST eg the table might
> contain 1,2,4,2,1,6,7,8,1,2 etc and I want 1,2,4,6,7,8
>

You could solve this by using a derived table

e.g.

select list(cast(somefield as varchar(8))) from
( select distinct somefield from sometable where ..... order by somefield
) as somederivedname

--
Jan-Erik

Jan-Erik


Neat - thanks

Roy Lambert