Tuesday, June 10, 2014

How to get the 4(n) right / left most numbers from an integer SQl SERVER

n right most numbers from an integer
SELECT CAST(RIGHT(CAST(Int AS VARCHAR(20)), [n]) AS BIGINT)
n left most numbers from an integer
SELECT CAST(LEFT(CAST(Int AS VARCHAR(20)), [n]) AS BIGINT)