Here is a simple example that selects the rows where the penultimate digit is 4
Names Default To Here( 1 );
dt = New Table( "hcarr01",
add rows( 100 ),
New Column( "example", set each value( Random Integer( -1000, 1000 ) ) )
);
// This is the selection statement to select the rows whose penultimate digit is 4
dt << select where( Substr( Char( :example ), -2, 1 ) == "4" );
Jim