I have created a new field in a table by rtrim(t.asset,’?’) as assetnew and would like to use assetnew to link to another table
when i try
where t.assetnew = x.sedol
i get invalid column name
can i use my rtrim formula field as a link to another table? if so, how?