Re: comparing the last 4 characters...
This works
select * from account
where account_number[6,9] = "2266"~
>
> something like this:
>
> select * from table1
> where table1.company = record.company
> and table1.city = record.city
> and table1.phone_no matches "*", record.phone_no[last 4 digits?]>
Good luck
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.;
cwoodall@vth1.vth.colostate.edu