On Friday 21 September 2001 15:44, you wrote:

Hi,

> > During the import of a large number of records, I need to check the last
> > character of a string contained in a varchar field for a certain value.
>
> perhaps COLUMN LIKE '%X' where X is the character you are looking for.

Thanks, I was looking for something that was harder than it needed to be <g>

Cheers

Phil

--
Linux 2.4.4-4GB
4:48pm up 9 days, 6:14, 1 user, load average: 1.25, 0.35, 0.18