Re: comparing the last 4 characters... (fwd)

From Storm Software: * * I may have missed some of what you are trying to get to but * you would get the last four digits of the telephone number as follows * * let x = length(record.phone_no) * let p_telephone = record.phone_no[x-4,x] * * Then make the SQL statement with p_telephone. <<stuff deleted>> Try again: let x = length(record.phone_no) let p_telephone = record.phone_no[x-3,x] Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) De Colores - Emmaus OC-13 | Fax: 714.771.3028 | \\`-'/ #include <disclaimer.h> SURF'S UP \\_/