I have a statement that I need to transport to a SQL Servr.

SELECT int(g1csf.pacid / 10^6) as ureg, * ;
FROM g1csf INNER JOIN g1_cnsin ;
ON G1csf.cnsinv = G1_cnsin.cnsinv ;
where substring(ltrim(str(g1csf.pacid,14)),8,2) ='20' ;
into cursor tests ;
having ureg >= 260000

How do I get the INT() functionality in SQL Servr 7 or 2000?

__Stephen