Re: cast integer to string

You could move the integer variable to a char variable, and then use substr on the char variable, using the length(char) to find out the max length of the string. Vandana ______________________________ Reply Separator _________________________________ Subject: cast integer to string Author: "David Grove" <david_grove@health.state.ak.us> at aflgate Date: 1/6/99 10:18 AM Folks, In a SELECT statement, is there some way to "cast" an integer data type to a string? The object is to manipulate substrings in the manner of 'column-name[1,3].' However, the 'column-name' I wish to manipulate is type integer. I apologize for this trivial-appearing question, but I can't seem to find anything in the manuals. For instance, TO_CHAR is nice, but applies only to datetime data types. I don't want to do an ALTER TABLE because I don't want to change the data type generally. Thanking you in advance, David Grove