Convert a String to an Integer Using SQL

select cast(Field1 as int), Field2 From MyTable

select cast('55' as int)

or in an SQL stored procedure...

declare @int as int
declare @str as int
set @int='55'
set @str=cast(@int as int)
select @str

Return From Convert a String to an Integer Using SQL to out Homepage