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

Posted in 1995

Storm Software — 10 Feb 1995 18:33:04 +0200 — source: Informix-list mailing list archive (1991-1998)

I realised afterwards, sorry ! Robert Minter (rob@dssmktg.com) wrote: : 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 \\_/ -- Neil - @storm@aztec.co.za < ANOTHER ESSEX LAD >