>>>Change where clause to
>>>
>>>where RTRIM(LTRIM(Item.ticket)) = RTRIM(LTRIM(temp))
>>
>>
>>OR AllTrim()
>
>In addition to Sergey's comment, LTRIM and RTRIM also work in Oracle. Alltrim does not.
And SQL Server too!!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao