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