Convert INT to VARCHAR in SQL (MSSQL)

20Dec/090

Convert INT to VARCHAR in SQL (MSSQL)

At some point you will need to change INT to VARCHAR for the purpose of manipulation like substring or to display it in the status windows when execute of stored procedure or trigger...

here is the code which you can use to convert / cast the INT to VARCHAR:

CONVERT(TYPE, VALUE)

in this case ( my case ), this was used:

	PRINT 'New revision updated for post id ' + CONVERT(VARCHAR(20), @intPID) + '!'

Good luck

Tagged as: microsoft, mssql, mssql2008, sql, sqlserver, Structured Query Language, t-sql Leave a comment

Comments (0) Trackbacks (0) ( subscribe to comments on this post )

No comments yet.

No trackbacks yet.

« NVARCHAR(MAX) now… JUSTHOST SCAM, dirty and fraud »

Licenses Status

VBB 4 Available: 0
VBB 4 Sold: 3
VBB 4 Suite Available: 0
VBB 4 Suite Sold: 9
VBB 3 Available: 0
VBB 3 Sold: 6
VbSeo Available: 0
VBSeo Sold: 4
IPB Available: 5
IPB Sold: 4

Spam cleared

9,620 spam comments blocked by
Akismet

DucDigital for ( $girl = 1; $girl < $required; $girl++ ) { echo “I love DucDigital”; }