Minor regex suggestion...
> Perhaps regular expression may help you out...
>
> WHERE field_name ~ '^AB' AND field_name ~ 'VN$'
That will still skip the records with trailing blanks.
WHERE field_name ~ '^AB.*VN[ \t\r\n]*$'
won't.
Jason
--
Indigo Industrial Controls Ltd.
64-21-343-545
jasont@indigoindustrial.co.nz