To convert int or any number to string in sql query we can use :
1 | CAST([datatoconvert] as VARCHAR(50)) as exp1 |
Or
1 | CONVERT(VARCHAR(50), [datatoconvert]) as exp1 |
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 |
Or
1 | CONVERT(VARCHAR(50), [datatoconvert]) as exp1 |