Ask Paula!

...bringing you notes from the field...
posts - 55, comments - 17, trackbacks - 0

My Links

News

Article Categories

Archives

Post Categories

.NET Development

Enterprise Integration

Java Development

Mobile/PDA Development

Professional Affiliations

Friday, August 07, 2009

How do I convert an integer to a string in SQL Server?


If you want to reformat data, use the function convert as shown:

select convert(varchar, cast(18 as integer)) as 'a number'

posted @ Friday, August 07, 2009 5:21 AM | Feedback (0) | Filed Under [ SQL ]

Powered by:

Copyright © Paula DiTallo 2007-2009 All Rights Reserved