Spearcross

All About Programming, Piece of My Mind, And Anything

To convert int or any number to string in sql query we can use :

1	CAST([datatoconvert] as VARCHAR(50)) as exp1

1	CONVERT(VARCHAR(50), [datatoconvert]) as exp1