>I'm trying to do this sql statement
>SELECT item.ticket, Item.item, item.serialnr, item.cat;
> FROM item;
> where (ltrim(Item.ticket)) = temp;
>
>I need to trim all the blanks out of this character field, but it wont do it in my where statement anyone know of a way to do this?
>
> Kelly
Change where clause to
where RTRIM(LTRIM(Item.ticket)) = RTRIM(LTRIM(temp))
--sb--