How would I....

Take the first letter of a varchar2 column and determine if it's a char or a number?
ie.

select decode(substr(name,1,1),<IF STRING>,name,'LOT '||name) from table

If the first char of the name column is a string then just use the name column, otherwise
concatenate the word 'LOT ' to the beginning of the column.

Thanks. Received on Mon Dec 03 2001 - 16:25:33 CST