select substr(card_number, -4) from card_number_table_name;
<awpaul_at_gmail.com> wrote in message
news:1172231600.492035.238080_at_t69g2000cwt.googlegroups.com...
> Hi,
>
> I can't work out how to do this:
>
> I have a table entry like this
>
> Card Number
> 123456789123456
>
> and a new table entry called last4digits
>
> - I am trying to make a sql query in Access which copies the last 4
> digits from card number and puts it into the last4digits column.
>
> Please help - I am clueless :-p
>
> thanks
>
Received on Fri Feb 23 2007 - 06:34:47 CST
