Numeric Identifiers

[Deltaflyer]

Is there anyway that i can identify if a field has numeric characters at the end of a string, I am not interested in the data if it has alpha characters as the last 2 digits in the field.

i.e. i want : abc12345, abc12346, abc12347, abc12348
but not : abc123ab, abc123ac, abc123ad, abc123ae

Thanks,
DeltaFlyer ;-)

DeltaFlyer - The Only Programmer To Crash With Style.

 

[MarkSweetland]

Replace Fld with applicable column identifier

IF  isnumeric(substring(Fld,len(Fld)-1,2)) > 0
 select 'Last two characters of Fld Numeric'
else
 select 'Non-numeric'

Mark

 

[Deltaflyer]

Thanks mark. DeltaFlyer ;-)

DeltaFlyer - The Only Programmer To Crash With Style.