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
<< SQL Server: Why do I get "multi-part identifier could not be bound" ? | Home | How do I create an Index that is NOT the primary on my tables? >>

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'

Print | posted on Friday, August 07, 2009 5:21 AM | Filed Under [ SQL ]

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

Powered by:

Copyright © Paula DiTallo 2007-2009 All Rights Reserved