I believe there is a function called Right(). Sample
is as follows (pardon the VB):
DIM sString, sLast4Characters
sString = "Hello There"
sLast4Characters = Right(sString, 4)
So, sLast4Characters now equals "here".
Hope this helps!
--- Hammad Nasim <[EMAIL PROTECTED]> wrote:
> Hi
> I need some help with substring. How can I extract
> last four digit of a
> field say card_no (this field has in some instance
> 10 digits and for some
> value has 20 digits).
>
> Thanks
>
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php