Dear Sir
I have a table with a column called ID_number that consists of ten digits
for each individual. I would like to truncate this column to create a new
column that will only display the first two digits of the ID_number. This
will allow me to calculate the clients current age.
Please assist.
Thanking you.
Kind regards.
Vinesh Govind
NBS - Marketing
(T) 364 2106
(F) 364 2915
Email: [EMAIL PROTECTED]
WARNING:
Any unauthorised use or interception of this email is illegal. If this email
is not intended for you, you may not copy, distribute nor disclose the
contents to anyone. Save for bona fide company matters, the BoE Group does
not accept any responsibility for the opinions expressed in this email.
For further details please see: http://www.nbs.co.za/emaildisclaim.htm
Notebook.jpg
Notebook.jpg