> >I am trying to create a view to take a variable that is filled with a >search string and query that against a SQL table that will partially match >the SQL table field. I can find the records of the search string matches >the whole table field but if only a part of the search string is found in >the record it returns nothing...Can anyone help here? Thanks again! > >Gary Have you tried AT(), ATC() ? hth Dezider --