Home Page for the TeradataForum
 

 

UDF Library: 'is_integer'

Component: 'verify.txt'


 
<< install_from_client.txt uninstall.txt >>


/*     Verify installation */

/*   regular numbers in strings   should all succeed */
sel is_integer('8');

/*   regular numbers in strings  with leading spaces  should all succeed */
/*   If UDF coded to ignore leading whitespace */
sel is_integer('     8');

/*   regular numbers in strings  with trailing spaces should all succeed */
/*   If UDF coded to ignore trailing whitespace */
sel is_integer('8    ');


/*   regular numbers in strings  with leading and trailing spaces */
/*   should all succeed */
/*   If UDF coded to ignore both leading and trailing whitespace */
sel is_integer('    8    ');

/* Anthing that is not a number will fail */
sel is_integer('abcd');
sel is_integer('a b c d ');
sel is_integer('Teradata');
sel is_integer('r6j15');
sel is_integer('1e9');
sel is_integer('175.8');


<< install_from_client.txt uninstall.txt >>





 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Jun 2020