Concatenating a string to a number
I have some numbers which are not uniform in size. Now if I have to put '.TIF' at the end of each number, which command can I use? For example, 123, 4567, 78901. This I want to update as 123.TIF, 4567.TIF...
All you need to do here is CAST the number as a VARCHAR datatype and then do the concatenation --
select cast(yournumber as varchar(8)) || '.TIF' from yourtable
When the number is converted to VARCHAR, it becomes a string that is just long enough to hold the digits of the number. Use a varchar length that is big enough to hold the largest number.
For More Information
- Dozens more answers to tough SQL questions from Rudy Limeback.
- The Best SQL Web Links: tips, tutorials, scripts, and more.
- Have an SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.