Please help - sql query - copying last 4 digits of a value to a new row.

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 - 05:53:20 CST