i have another function i need converted to ase. the string function. trying to enter a nbr from a string column into an int column. thanks for your time.

string(loc_st_name, 1, patindex('% %',loc_st_name)), ' ' , substring(loc_st_name, patindex('% %',loc_st_name)+1 ,2) as integer,