Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help - sql query - copying last 4 digits of a value to a new row.
<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
>
SELECT right(name.name,4)
FROM name;
Received on Fri Feb 23 2007 - 09:44:09 CST