>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


Perhaps there are some leading or trailing blanks in Temp which are getting in the way??

Have you tried ALLTRIM(item.ticket) = ALLTRIM(temp)