substring

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

mysql and client server

Does Mysql can be used in client server envorinment. Hammad Nasim New Core Networks 1032 Castro Street Mountain View, CA 94040 P 650-691-1400 F 650-938-1730 http://www.newcorenet.com - Before posting, please check: http