Entry

Using sql how do i select a portion of a field for eg 00091234 i only need 91234

Aug 22nd, 2002 03:10
Michael Wandha, Ivan Lutrov,

If you're after the last five characters of the field, try:
   select right(fieldname, 5) from tablename;

====== Added by M.Wandha =====
Alternatively, if the field contains a string of numeric characters, 
use the "Val" function. Thus, Val("000912345") would result in 912345.